I am needing to convert date/timezone to an end user. I am trying to write a script that will allow professionals to setup a meeting time in a database in their timezone but automatically convert to other users in their stored timezone:

So I have a meeting time database:


Date -Time - Timezone

11-15-2012 - 9:00 P.M - America/Indiana/Tell_City
11-15-2012 - 10:00 A.M - America/Kentucky/Louisville
11-15-2012 - 7:00 A.M - America/Chicago

The end user has their timezone stored in the database

Username - TimeZone

Test - America/Indianapolis



How would I get the data from the first table of meeting for instance that is in the America/Chicago timezone to automatically show in the America/Indianapolis timezone of the end user?