RE: Date format

You're welcome.

Was able to confirm (2 minutes after sending first reply), that DATE datatype does not handle timezone in any way, shape or form. And pardon my syntax mistake; the new-ish 9i datatype is TIMESTAMP WITH [LOCAL] TIME ZONE, not "TIMEZONE".

• bill c.

-----Original Message-----

From: Chadi Kassan [mailto:chadi_at_myvirtualmodel.com] Sent: Monday, December 13, 2004 11:18 AM To: 'Bill Coulam'
Subject: RE: Date format

very appreciated.

;)

-----Original Message-----

From: Bill Coulam [mailto:bill.coulam_at_scgo.com] Sent: Thursday, December 09, 2004 11:18 AM To: chadi_at_myvirtualmodel.com; oracle-l_at_freelists.org Subject: 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_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 Mon Dec 13 2004 - 12:36:16 CST