RE: Date format

very appreciated.

thanks again.

-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante@xxxxxxxxxxxxxxxxx]
Sent: Thursday, December 09, 2004 11:05 AM
To: 'chadi@xxxxxxxxxxxxxxxxxx'; oracle-l@xxxxxxxxxxxxx
Subject: RE: Date format


How about this:

SELECT TO_DATE(SUBSTR('Mon DEC 06 12:11:39 EST 2004',5,15)||
               SUBSTR('Mon DEC 06 12:11:39 EST 2004',25,4),'MON dd
hh24:mi:ssyyyy') FROM dual

Tom

-----Original Message-----
From: Chadi Kassan [mailto:chadi@xxxxxxxxxxxxxxxxxx] 
Sent: Thursday, December 09, 2004 10: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: