Oracle Database and Oracle Applications
Search This Blog
Showing posts with label
Oracle Date Format Conversion
.
Show all posts
Showing posts with label
Oracle Date Format Conversion
.
Show all posts
Monday, November 22, 2010
Date Format Conversion
How to convert Mon Nov 19 19:00:17 PST 2007 covert to "MM-DD-YYYY HH:MI:SS" FORMAT?
Solution:
select to_char(to_date(replace('Mon Nov 19 19:00:17 PST 2007','PST',''),'DY Mon DD HH24:MI:SS YYYY'),'MM-DD-YYYY HH:MI:SS') from dual;
Older Posts
Home
Subscribe to:
Posts (Atom)