List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 1 2003 6:41pm
Subject:Re: DATE Data type quandry
View as plain text  
At 12:12 -0700 5/1/03, Richard Reina wrote:
>I have a table called contact with a column called birthday so we 
>can be allerted of a contact's approaching birthday.  SInce the year 
>is not necessary and often times hard to obtain we have made the 
>field a character field storing the month and the day.  This however 
>makes it difficult to query and requires a lot complicated *if * 
>statements in the code.  Does anyone know a better way?

Three separate integer columns, with the year column allowed to be NULL?


Paul DuBois
sql, query
DATE Data type quandryRichard Reina1 May
  • Re: DATE Data type quandryPaul DuBois1 May
    • Re: DATE Data type quandryJeremy Zawodny1 May
  • Re: DATE Data type quandryCal Evans1 May