I have a .NET visual Studio 2005 question... I have a client app that runs off desktops across the world. It allows the user's to run in their local culture. All of the database access is handled on a central server (located in the US on the east coast in the EST time zone). We use remoting to enable the client and the "business" (database) code to communicate and subsequently issue stored proc calls. We wanted to have all date/times that were saved into the database be in the EST timezone (most users are in the US and it seemed confusing to store dates/times in local time zones and really not have a reference as to what time zone it was in and therefore, not knowing REALLY what time an action was initiated).
Anyway, currently, when the users outside of the EST time zone use the system, their local date/time is entered into the database.
Is there an EASY way to change the timezone used by a thread (similar to the way we can change the culture of the thread) so that all interaction for the client thread could be done in the same timezone as the dates/times we want to store in the database? I don't really want to change the visual format of the dates/times, just the zone.