MySQL Forums
Forum List  »  PHP

Re: Unexpected Data truncated for Date
Posted by: Peter Brawley
Date: June 12, 2019 08:10PM

SQL dates work only with 4-digit years (1000-9999), b Beyond that range there are many issues.

I think a common solution is to store year month and day as separate columns, and compute date values based on the various calendar adjustments that have occurred since humans started writing down dates.

Options: ReplyQuote


Subject
Written By
Posted
Re: Unexpected Data truncated for Date
June 12, 2019 08:10PM


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.