MySQL Forums
Forum List  »  Knowledge Base

Re: Convert Date Format
Posted by: Paul Svirin
Date: October 06, 2009 02:41AM

What about this one:

mysql> select case when length( 'Tue sep 01 00:00:00 GMT 2009' )=28 THEN CONCAT( SUBSTRING( 'Tue sep 01 00:00:00 GMT 2009', 1, 20), RIGHT( 'Tue sep 01 00:00:00 GMT 2009', 4 ) ) ELSE 'Tue sep 01 00:00:00 2009' END as date;

+--------------------------+
| date |
+--------------------------+
| Tue sep 01 00:00:00 2009 |
+--------------------------+
1 row in set (0.00 sec)

This can be formed as stored procedure.

---------------
StarWind Software developer ( http://www.starwindsoftware.com )

Options: ReplyQuote


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