MySQL Forums
Forum List  »  Newbie

Re: How to convert existing date values in different format
Posted by: Rick James
Date: November 06, 2014 04:55PM

I'll second Peter's snide comment about your job position.

Some other ugly programming solutions:

* A TRIGGER that fixes the date as it is inserted/updated.

* Fix the dates as you SELECT them, using a CASE statement with Peter's regexp, etc.

Options: ReplyQuote




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.