How to get entries from DB depending on timezone?

[eluser]esset[/eluser]
Wow - thanks for all the good comments.

Jelmer: In what format do you store the shows date?

Do you store them as GMT+0 or as they are with the GMT calculated in? (Maybe its the same result in the end?)

Code:

strtotime('2010-04-12 15:00:00 +0300');
strtotime('2010-04-12 18:00:00 +0000');

Also would this approach give you shows that overlap months, i.e. if a show airs at 2010-04-30 23:30 at GMT+5 and you are in Europe (which would make the airdate 2010-05-01 05:30)?


Thank you so much for the help, this is clearing up a lot for me