Oracle db: how to get current_time?

Question

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

select current_time

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

score 2 · Answer 1 · answered May 14 '18 at 17:54

2

You can use SYSDATE:

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

answered May 14 '18 at 17:54

Yogesh Sharma

It is converted to string. can it be mapped to java.sql.Time for JDBC? – eastwater May 14 '18 at 18:06
Yes. Don't convert it to a string if you want a datetime. – William Robertson May 14 '18 at 19:27
@Sunnyday: Oracle has no `time` data type. – May 14 '18 at 21:03

1 Answers1