MySQL Forums
Forum List  »  Knowledge Base

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'

Options: ReplyQuote


Subject
Views
Written By
Posted
Convert Date Format
7316
September 22, 2009 12:17PM
3026
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.