Oracle Database and Oracle Applications
Search This Blog
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;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment