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@xxxxxxxxxxxxxxxxxx]
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@xxxxxxxx]
Sent: Thursday, December 09, 2004 11:18 AM
To: chadi@xxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@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: