Another possible solution would be to store partial dates as, for example, 2004-05-01. In other words, simply make the partial date the same as the first day of that month. This has the advantage that range date range functions work, but you will not be able to tell the difference between a partial date and a complete date.
Cheers Andrew. ----- Original Message ----- From: "Michael Stassen" <[EMAIL PROTECTED]> To: "Jochem van Dieten" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, June 22, 2004 8:30 PM Subject: Re: New to Dates - Plain English Please > > Jochem van Dieten wrote: > > > Michael Stassen wrote: > > > >> Jochem van Dieten wrote: > >> > >>> David Blomstrom wrote: > >>> > >>>> > >>>> Suppose you have a list of dates in the proper format, > >>>> like this: > >>>> > >>>> 2004-02-04 > >>>> 2003-11-02 > >>>> > >>>> and you encounter a date with only the month and year, > >>>> like May 2002. How would you insert that > >>> > >>> > >>> Not. Prompt the user for a full date. > >> > >> > >> That is not strictly true. > > > > > > It is what I would do, therefore it is a true answer to the question. > > > > Jochem > > Then I misunderstood you. I took your answer to mean that you cannot store > dates without the day part, rather than that your advice was not to do so. > I accept your explanation that you meant the latter, but I don't think > that's clear from your original wording. > > Perhaps you read an accusatory tone in my choice of wording. That was not > my intent, and for that I apologize. > > Michael > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
