Zeros in Dates
Posted by:
Gary Luke
Date: November 22, 2025 01:41AM
In a genealogical database I need to hold dates in a date type field with zeros such as 1873-00-00. More recent versions 8 & 9 of MySQL don't allow it so I've had to go back to one of the versions 5.
But is there any way to configure version 9 to allow dates with parts as zeros, globally for all databases?
Thanks for any help
Gary
Subject
Written By
Posted
Zeros in Dates
November 22, 2025 01:41AM
February 11, 2026 10:54AM
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.