Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

TO_CHAR(sysdate,HH24

SQL> SQL> select TO_CHAR(sysdate,'HH24:MI:SS') from dual; TO_CHAR( -------- 19:26:37