RE: Date format

The DATE datatype and its conversion routines don't really handle time zone
code all that well, AFAIK.

The time zone should be stored in a separate column, or use the new
TIMESTAMP with TIMEZONE datatypes.

If you lose the "EST", it can be done:
SELECT TO_DATE('Mon Dec 06 12:11:39 2004','Dy Mon DD HH24:MI:SS YYYY')
FROM dual

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Chadi Kassan
Sent: Thursday, December 09, 2004 9:57 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Date format


Hi every one,

Can this varchar2 be converted to oracle date :

Mon Dec 06 12:11:39 EST 2004

Thanks
--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Other related posts: