How to get entries from DB depending on timezone?

[eluser]esset[/eluser]
I have a small issue I've never been faced with before, and I need some help

I have TV-episodes in a database. They have a name, airdate and airtime. Like this:

Code:

************************************
name | airdate | airtime
************************************
Show 1 | 2010-04-01 | 12:00
Show 2 | 2010-04-02 | 23:00
Show 3 | 2010-04-02 | 23:30
************************************

Now I have a calender were I want to display which day the episode airs depending on the users timezone prefs.

So it let's say an american person visits the calendar "Show 2" will be on the 2th, but if a european person visits the calendar "Show 2" might be on the 3th (for him).

Any idea how I can accomplish this?


All ideas are welcomed. Thank you.