Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

NEW_TIME() returns the zone_two equivalent of the zone_one date

SQL> SQL> Syntax: NEW_TIME(<date>, <zone_one>,<zone_two>) 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>