How to convert "Thu Nov 17 06:44:23 CST 2005" to date ?
From: <admin_at_rbtron.com>
Date: Tue, 10 Mar 2009 14:04:35 -0700 (PDT)
Message-ID: <38abdd47-5fa6-4a75-82c7-b26c20f503c5_at_j12g2000vbl.googlegroups.com>
Hi,
Date: Tue, 10 Mar 2009 14:04:35 -0700 (PDT)
Message-ID: <38abdd47-5fa6-4a75-82c7-b26c20f503c5_at_j12g2000vbl.googlegroups.com>
Hi,
How to convert "Thu Nov 17 06:44:23 CST 2005" to date ?
This works :
select to_date('Thu Nov 17 06:44:23 2005','Dy Mon DD hh24:mi:ss yyyy') from dual;
But when timezone is added in between, it doesn't.
Thanx
-Adm Received on Tue Mar 10 2009 - 16:04:35 CDT