How to get entries from DB depending on timezone?

[eluser]esset[/eluser]
Hi Luben

Thanks for your response. After reading through the page I can't say I'm much further to solving my issue, hehe.

When he say..

If we store “absolute” times in the database, then displaying times to users becomes a localization issue.

.. he kind of lost me. Does that mean storing the date as if it was GMT +- 0 ? So for "Show 1" which let's say have GMT+3 we store it as 9:00(?), then work from there?


I'll have as he says making the user choose their GMT offset, like +1, +2, -5 or so. But how do I then query my database to get the correct results for the correct day?


Thanks for you help