Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. NEW_TIME() returns the zone_two equivalent of the zone_one date
SQL>
SQL>
Syntax: NEW_TIME(, ,)
SQL>
SQL> SELECT
  2     NEW_TIME(SYSDATE, 'PST','AST')   ast_time,
  3     SYSDATE   pst_time
  4  FROM dual;
AST_TIME  PST_TIME
--------- ---------
21-JUN-08 20-JUN-08
SQL>