CODEWITHSUNDEEP
sqloracle-databasecurrent-time
eastwater
eastwater

Reputation: 5572

Oracle db: how to get current_time?

Mysql has current_time. What is the equivalent for oracle db?

select current_time

current_time
--------------------
15:30:16

Upvotes: 1

Views: 889

Answers (1)

Yogesh Sharma
Yogesh Sharma

Reputation: 50163

You can use SYSDATE:

SELECT TO_CHAR(SYSDATE, 'HH24:MI:SS') "current_time"
FROM DUAL;

Upvotes: 2

Related Questions