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;