My Application hosted at server in time zone which differs from mine. All date in database is not correct for my time zone. How can I set my time zone for Application or how I can convert date to my time zone on output
+1
A:
Don't set the time zone for the process - use TimeZoneInfo from .NET 3.5 and higher to perform the relevant conversions.
Of course, that assumes you know the time zone that the data will come back in from the database... usually database records are kept in UTC, but not always...
Jon Skeet
2010-07-07 20:01:10
just to add, keep all your dates in the db in UTC, and just convert them when you need to display them.
dave thieben
2010-07-07 21:07:08