Capturing EDT/EST timezone with TIMESTAMP datatype
129898Jun 15 2003 — edited Jun 20 2003Hi guys,
In 9i DB, I need to capture date and timestamp with EDT or EST time zone specifiers. For testing pursposes, I wrote the following code and the result is as:
SET SERVEROUT ON
DECLARE
v_date TIMESTAMP WITH LOCAL TIME ZONE;
BEGIN
v_date := TIMESTAMP '2003-06-15 12:16:30 US/Eastern EDT';
DBMS_OUTPUT.PUT_LINE(v_date);
END;
/
I get the following result:
15-JUN-03 12.16.30.000000 PM
Actually I need 15-JUN-03 12.16.30.000000 PM EDT or EST depending on the daylight times in the Eastern coast. Also, I did change my SESSION with ALTER SESSION SET TIME_ZONE='US/Eastern' but still I do not get the promising output. I just put it to the forum in the hope if someone could help me out with the new timestamp datatype in this case please.
Any help will highly be appreciated.
Thanks
Zahir