Localised timezones?

[eluser]Michael Wales[/eluser]
Wish I would have seen this one before you figured it out pyro. People always give me a hard time when I tell them to always store date/time as a Unix timestamp (rather than a MySQL Date/Time field). This is exactly why - you see how beautiful and functional that function is? 5 lines - and it works exactly as you would expect it to.

Plus, Unix timestamps just make more sense, and damn near all of the PHP Date/Time functions use a Unix timestamp for their calculations. Why insert a MySQL date/time field when you are going to convert it to Unix everytime you retrieve it?