[SOLVED] Best way to store dates when you don't always have a complete date

[jb22b4]

I need to store dates and be able to order by date.  How should I accommodate a situation where the user only knows part of the date, like only the year, or only the month?

 

Thanks for the help,

Justin

[.josh]

In that case I'd store as a delimited string, or else have a separate column for each part of the date.

[fenway]

In that case I'd store as a delimited string, or else have a separate column for each part of the date.

FYI, MySQL has no problem storing partial dates.