Date Time Zone problem

[akkerend]

Convert the date column with SQL function NEW_TIME.

NEW_TIME(d, z1, z2), returns the date and time in time zone z2 when date and time in time zone z1 are d.

SELECT new_time(sysdate,'PST','EST') FROM dual;