RE: Date format

From: Bill Coulam <bill.coulam_at_scgo.com>
Date: Thu, 9 Dec 2004 10:18:21 -0600
Message-ID: <FJEOLLFBELDPHAFFABKMCEPDCCAA.bill.coulam@scgo.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Chadi Kassan Sent: Thursday, December 09, 2004 9:57 AM To: oracle-l_at_freelists.org
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 Received on Thu Dec 09 2004 - 10:15:41 CST