How to get entries from DB depending on timezone?

[eluser]esset[/eluser]
Thanks for your help Lyuben.


My trouble isn't really detecting the timezone, since i'll let my user choose his/hers timezone from a settings dropdown.

What I wonder is how I store the correct time for the shows, and how I query the database to recieve the correct results depending on the users timezone (GMT offset).

I might add that each show also have it's GMT offset (like GTM +5) in it's own field.


Any ideas regarding that?

Thanks