RE: Date format

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Thu, 9 Dec 2004 11:04:45 -0500
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0702A970FE@exchsen0a1ma>

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:03:44 CST