How to change the system date and time into correct time zone

Question

I have two fields,

CreatedDate

UpdatedDate

It takes from the system date and time.. My sql server is located at UK. So when i see in site it is showing wrong time.. how to change this in mvc?

My details page, i am showing like following,

 <strong>Date Posted:</strong>
            <%:Model.CreatedDate%>

Please give me the ideas?

Start here: http://stackoverflow.com/questions/2532729/daylight-saving-time-and-time-zone-best-practices — Matt Johnson-Pint, Sep 05 '13 at 04:56

score 0 · Answer 1 · answered Sep 05 '13 at 04:30

0

I would store your dates using UTC and then use that as a baseline for converting to the appropriate timezone for your region. This makes it flexible since you have a constant reference point.

answered Sep 05 '13 at 04:30

TGH

37,937
11
96
131

how to use UTC time? I am not familiar with this? can u give me some example? – PoliDev Sep 05 '13 at 04:37

How to change the system date and time into correct time zone

1 Answers1