Is there a way to find the timezone in Oracle 9i?
I need to pass in a date and return 'GMT' or 'BST'
Printable View
Is there a way to find the timezone in Oracle 9i?
I need to pass in a date and return 'GMT' or 'BST'
Refer to NEW_TIME/DBTIMEZONE functions
from docs:
Code:The following example returns an Atlantic Standard time,
given the Pacific Standard time equivalent:
ALTER SESSION SET NLS_DATE_FORMAT = ’DD-MON-YYYY HH24:MI:SS’;
SELECT NEW_TIME(TO_DATE(
’11-10-99 01:23:45’, ’MM-DD-YY HH24:MI:SS’),
’AST’, ’PST’) "New Date and Time" FROM DUAL;
New Date and Time
--------------------
09-NOV-1999 21:23:45