Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. Select to_char( sysdate, DDMMYY HH24
SQL>
SQL>
SQL> select to_char( sysdate, 'DD/MM/YY HH24:MI:SS' ) "Right Now"
  2  from dual
  3  /
Right Now
-----------------
16/06/08 17:28:47
1 row selected.
SQL> --