We are using Microsoft SQL 2005 for our database for a .net remoting application. The application is used in several time zones and accesses the same SQL Server which is in the EST time zon. Here is my question:
We store an appointment date as the date and time. When the SQL Server in the EST zone passes the time to a client in the CST zone, the client changes the time to CST. We do NOT want this to happen. We are performing our own calculation for the time in the client application based on the users division. How can we tell the client to get the data, but do not calculate the data to the time zone of the workstation.
Any help would be greatly appreciated.