This content has been marked as final. Show 3 replies
From the docs
This function takes as input only a limited number of time zones. You can have access to a much greater number of time zones by combining the FROM_TZ function and the datetime expression. See FROM_TZ and the example for "Datetime Expressions".
The arguments timezone1 and timezone2 can be any of these text strings:
AST, ADT: Atlantic Standard or Daylight Time
BST, BDT: Bering Standard or Daylight Time
CST, CDT: Central Standard or Daylight Time
EST, EDT: Eastern Standard or Daylight Time
GMT: Greenwich Mean Time
HST, HDT: Alaska-Hawaii Standard Time or Daylight Time.
MST, MDT: Mountain Standard or Daylight Time
NST: Newfoundland Standard Time
PST, PDT: Pacific Standard or Daylight Time
YST, YDT: Yukon Standard or Daylight Time
You might be better to use the from_tz function or
If you need it as a date data type after that, you can cast it back...
select TO_TIMESTAMP_TZ('07-JUL-2011 20:00 Africa/Nairobi', 'DD-MON-YYYY HH24:MI TZR') at time zone 'Europe/London'from dual;
select CAST(TO_TIMESTAMP_TZ('07-JUL-2011 20:00 Africa/Nairobi', 'DD-MON-YYYY HH24:MI TZR') at time zone 'Europe/London' AS DATE) from dual;