|
Home > Archive > MySQL Server Forum > March 2005 > Re: Storing partial dates
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: Storing partial dates
|
|
| Ray Gurganus 2005-03-30, 9:40 am |
| "Murphy" <m@urphy.com> wrote in message
news:k4K1e.14933$C7.11637@news-server.bigpond.net.au...
> I am creating my first mySQL database to store genealogy information and
> would like fields for date of birth and date of death.
I did a genealogy database myself, and for this I created two date fields
for each case - one as a text field that stores what is typed in, and a
second that converts this to the actual closest date for sorting and
comparison purposes. So "March 1900" is coverted over to 1/1/1900 in the
actual date field, but the application displays the text field.
| |
| Murphy 2005-03-30, 9:40 am |
| Ray Gurganus wrote:
> "Murphy" <m@urphy.com> wrote in message
> news:k4K1e.14933$C7.11637@news-server.bigpond.net.au...
>
> I did a genealogy database myself, and for this I created two date fields
> for each case - one as a text field that stores what is typed in, and a
> second that converts this to the actual closest date for sorting and
> comparison purposes. So "March 1900" is coverted over to 1/1/1900 in the
> actual date field, but the application displays the text field.
Excellent solution...
--
Thanks
Murph
|
|
|
|
|