List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:May 22 2000 3:00pm
Subject:Re: Wish there was one type to hold dates with and without years
View as plain text  
tepperly@stripped wrote:

> Description:
> 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?



Thread
Wish there was one type to hold dates with and without yearstepperly22 May
  • Re: Wish there was one type to hold dates with and without yearsGerald Clark22 May