Convert Date Format
Posted by:
airease 16
Date: September 22, 2009 12:17PM
My sql version is 5. i want to convert date in format 'Tue sep 01 00:00:00 GMT 2009' into '2009-09-01 00:00:00'. I have tried Date_Format and str_to-date functions but if string contains timezone for eg. 'GMT' it doesn't convert it and gives null value. How can i convert date 'Tue sep 01 00:00:00 GMT 2009' into format '2009-09-01 00:00:00'
Subject
Views
Written By
Posted
Convert Date Format
7387
September 22, 2009 12:17PM
3059
October 06, 2009 02:41AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.