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" <Michael.Stassen@stripped>
To: "Jochem van Dieten" <jochemd@stripped>
Cc: <mysql@stripped>
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/mysql?unsub=1
>
>
