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
Central Standard Time US/Central -6.00 12/15/13 10:00 AM 12/15/13 4:00 PM 12/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.