How to display current system time in SQL.

g.sreemayee

 Profile Answers by g.sreemayee Questions 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.

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• May 7th, 2010

You can get the time asSELECT TO_CHAR(SYSDATE, 'HH24:MI:SS')FROM DUAL;

Answer Question  Select Best Answer