dj_dj_dj

 Profile Answers by dj_dj_dj 

• May 6th, 2010

 

select current_timestamp
from  dual;

Waseem Mehmood

 Profile Answers by Waseem Mehmood 

• May 7th, 2010

 

You can get the time as

SELECT TO_CHAR(SYSDATE, 'HH24:MI:SS')

FROM DUAL;

g.sreemayee

 Profile Answers by g.sreemayee 

• May 19th, 2010

 

select to_char(sysdate,'HH24:MM:SS') from dual;

select current_timestamp from dual;

These two will give the current time of the system.

1. ll give the time only.

2. ll give the time with the date.