MySQL Forums
Forum List  »  Newbie

Re: How to convert existing date values in different format
Posted by: Phillip Ward
Date: November 07, 2014 06:25AM

Quote

I can't deny that I am in a sink hole for now but hopefully we are migrating to a new architecture soon.
And you can bet that any "new architecture" is going to look at this non-sensical, inconsistent "date" field like something it just scraped of the bottom of its shoe!

I would recommend that you add a new, Date field that you populate via a Trigger. This has a number of benefits, not least of which (a) people might actually start using the new field instead of the messy thing that they have to "think" about and (b) even if the new field isn't used now, it will make migration into anything "new" one step easier.

Regards, Phill W.

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.