Unanswered: Time zones - convert local time to GMT
I'm working with SQL 2000. The database server is located in the Pacific Time zone. Data will be collected from branches in other time zones (CT, MT, ET, etc.). Is there a stored procedure that can convert the timestamp on the data retrieved from different time zones into GMT?