Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Conversion Functions

 

To_char(sysdate,hh24

SQL> SQL> select sysdate                       as today   2  ,      to_char(sysdate,'hh24:mi:ss') as time   3  from dual; TODAY     TIME --------- -------- 24-JUL-08 18:56:03 SQL>