How to fetch client time zone &convert DateTime stored in DB

Question

How to capture Client Time Zone and use this to convert the Date and time stored in Data Base tables(in UTC) to client time zone accordingly.

Sanjeeb Lenka · Answer

check these links http://stackoverflow.com/questions/9869051/how-to-convert-datetime-in-specific-timezone http://stackoverflow.com/questions/3672941/formatting-dates-and-datetimes-for-users-timezone-including-timezone-offset-in

Santhosh Kumar Jayaraman · Answer

try this var utcNow = DateTime . UtcNow ; SaveToDB ( utcNow ); to retrieve: var utcFromDb = RetrieveTimeFromDb (); var localTime = DateTime . ToLocalTime ( utcFromDb );