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