Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

To_char( sysdate, HH24

SQL> SQL> SQL> SQL> select to_char( sysdate, 'HH24:MI:SS' ) "DATE" from dual; DATE -------- 20:44:28 SQL>