Re: BCE/CE Dates

2004-02-19 Thread Craig A. Finseth
... I have a, possibly not so unusual problem, with dates. The standard MySQL datatime accounts for all dates starting between the year and inclusive. ... Take a look at using Julian Day numbers. This date form is used in astronomy and general calendar conversion

BCE/CE Dates

2004-02-18 Thread Peter Stradinger
I have a, possibly not so unusual problem, with dates. The standard MySQL datatime accounts for all dates starting between the year and inclusive. The problem I'm having is that I have a client who wants to build a database for an art-history collection. We'd like to be able to date