How to get entries from DB depending on timezone?

[eluser]WanWizard[/eluser]
Unfortunately, dealing with timezones is a lot more complicated than this.

DST rules change on a regular basis. To be able to convert a date/time input on a form by a user, you need to know to which timezone that date/time belongs. You then have to figure out the DST settings for that date/time given the timezone. Now you can convert it correctly to GMT. When you want to display it, you need to know the timezone in which to display it, and the DST settings in that timezone for the given date/time. Now you can convert the stored GMT timestamp to the proper 'local' value.

Check this http://derickrethans.nl/storing-date-tim...abase.html from the author of PHP's new DateTime class...