Roland Corbet said:
>
> However, although there are relatively few pieces of history we need
> to store before the year 1000 they are equally important. We are
> likely to have dates such as 0005-04-10 or even BC dates
> (-)3000-00-00.
> Alternatively, is there a better method which I could use?
Reading the details of the Date and Datetime datatype at:
http://www.mysql.com/doc/en/DATETIME.html
I see that 1000-01-01 is the earliest date that MySQL "supports" in this
datatype.
We have an application that needs to store a lot of historical data, the
majority of which will fit nicely above
