Date Timezone Oracle PLSQL

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