Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Date format
very appreciated.
thanks again.
-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante_at_labor.state.ny.us]
Sent: Thursday, December 09, 2004 11:05 AM
To: 'chadi_at_myvirtualmodel.com'; oracle-l_at_freelists.org
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_at_myvirtualmodel.com]
Sent: Thursday, December 09, 2004 10: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:07:57 CST
![]() |
![]() |