...
I have a, possibly not so unusual problem, with dates. The standard MySQL datatime
accounts for
all dates starting between the year 0000 and 9999 inclusive.
...
Take a look at using Julian Day numbers. This date form is used in
astronomy and general calendar conversions.
Every day has an integer number and it handles pretty much any date
you can imagine (as in the lifetime of the universe).
Just convert your dates to JDNs for storage and convert back for display.
Lots of code out there to do this.
Craig
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
