MySQL Forums
Forum List  »  Other Migration

Re: Pointless Whining about Bad Dates
Posted by: Peter Brawley
Date: January 08, 2019 11:15PM

> replacing the instances of DATE with an INT field.

Yikes, piling kludge upon kludge, hack upon hack. Errors multiply as you see. You've been misusing the date type.

Better solution: create yr,mo,day columns, export data from your date column to those columns, adjust indexes and insert/update logic accordingly.

> It is annoying that MySQL complains ...

An RDBMS implements a rigorous theory of database management. It isn't a freeform innovation project. As mysql use cases get more sophisticated, hacks and kludges of the sort you describe here become more problematic, less tolerable. Most of us need mysql to improve its ISO SQL compliance, as it's doing.

Options: ReplyQuote


Subject
Views
Written By
Posted
102
January 08, 2019 04:38PM
Re: Pointless Whining about Bad Dates
44
January 08, 2019 11:15PM


Sorry, only registered users may post in this forum.

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.