> I would like to use MySql to hold phone/address list type data. For
> some people, I have their birthday and/or anniversary. In some cases,
> I have the Month, Day and Year of the event; in other cases, I only
> have the month and day. It would be nice if there was an SQL datatype
> to hold either kind of date.
> Originator: Tom Epperly <tomepperly@stripped>
> Organization: Home user
> MySQL support: none
> Synopsis: No problem just wish date data type could store days without years
> Severity: non-critical
> Priority: low
> Category: mysql
> Class: change-request
> Release: mysql-3.22.32 (Source distribution)
Since there is no year zero, why not use year zero when year is unknown?