Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Combine to_char and trunc with date value

SQL> SQL> select to_char( trunc( sysdate, 'HH' ), 'DD-MON-YY HH24:MI:SS' ) "The Current Hour"   2  from dual   3  / The Current Hour ------------------ 16-JUN-08 17:00:00 1 row selected. SQL> SQL> --