Our SQL Server is in Pacific

Our Time Recording system is in GMT

For each timezone, I need to run a report at 10:00 in the employee timezone or it could be 8:00 just depends want I want to do the report.

So if i choose 10:00 for users in Pacific Time Zone, the run time on our app will run at 6 PM

Central 4 PM

Table

Time Zone

Central Standard TimeUS/Central-6.0012/15/13 10:00 AM12/15/13 4:00 PM12/15/13 8:00 AM

How to pass in RunTime Expected time 10:00 and it to return the time GMT, and PCT, CT etc for all time zones.