Localised timezones?

[eluser]xwero[/eluser]
unix timestamps are good within the brief time they are usable (from 1970 to ... with a quirk 19-01-2038). The mysql date has a bigger reach (1000-01-01 to 9999-12-31) when you store it as a number.

I have had a few sites where they wanted to archive their first data that was before 1970 so i had to write functions based on the mysql date.