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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l