Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. 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> --