How to install TimeZone for my ASP.NET (MVC) application

Question

My application is hosted on a server in a time zone that is different from mine. The entire date in the database is incorrect for my time zone. How can I set my time zone for the application or how can I convert the date to my output time zone

Answer 1

Do not set the time zone for the process - use TimeZoneInfofrom .NET 3.5 and higher to perform the corresponding conversions.

Of course, it is assumed that you know the time zone that the data will be returned from the database ... usually the database records are stored in UTC, but not always ...