Conversion Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Conversion Functions
  4. 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>