SQL> SELECT from_tz(CAST (SYSDATE AS TIMESTAMP), '+01:00') tz FROM dual; TZ ------------------------------------------------- 07/03/14 09:47:06,000000 +01:00
SQL> SELECT from_tz(CAST (SYSDATE AS TIMESTAMP), '+01:00') tz FROM dual; TZ ------------------------------------------------- 07/03/14 09:47:06,000000 +01:00