How to get entries from DB depending on timezone?

[eluser]danmontgomery[/eluser]
[quote author="Jelmer" date="1271125692"]I solve this problem by saving the UNIX timestamp (generated by strtotime()) instead of a formated date. That makes it possible to use dates/times with calculation. That way you save everything in seconds before or after the UNIX epoch (January 1st, 1970 GMT) and it allows for easy conversion to whatever limits you want. All you have to do is caculate the timestamp of you limits (taking the timezone into consideration) to and query using those.[/quote]

It's not really any easier to perform date calculations in unix timestamps than it is a datetime field... Any comparison, formatting, or manipulation is done natively in MySQL with datetime fields, and can be easily converted using strtotime() in PHP... It really just comes down to personal preference.

That said, you might be able to use the CONVERT_TZ() function in mysql, something like:

Code:

SELECT CONVERT_TZ('2010-04-02 23:00:00', '-05:00', '+02:00')

http://dev.mysql.com/doc/refman/5.1/en/d...convert-tz