Artist dates displayed incorrectly

[CHz]

Compare Richard Joseph (April 23, 1953–March 4, 2007) with Fryderyk Franciszek Chopin (March 1, 1810–October 17, 1849). In Chopin's birth field, the year is left off (notice Joseph's has the year), although the day and month are correct. In the death note, it says he died on Dec 31 1969 instead of the proper day.

I think the problem lies with the use of the PHP date function for date formatting, because the lowest valid timestamp is Fri, 13 Dec 1901 20:45:54 GMT. I played around with the dates, and both of them start displaying incorrectly once you go past December 13, 1901. December 14 and later are all fine.

I'd guess the same problem also happens with album dates, but I didn't check to make sure. I think it'll be a long time before there are any albums in the database that came out before December 13, 1901 or after January 19, 2038, anyway.

[Gigablah]

It's a problem with using PHP timestamps to represent dates. I've already started working around this with some of the newer fields (like group member join/part dates), storing them as DATE (####-##-##) rather than timestamp integers. The others need to be converted.