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>