Display current datetime depending on client

Question

I am currently saving the datetime.utcnow in the database on azure but im not sure how to display the correct time depending on the client.
Should I be using utc? Should I save the timezone so I can recalculate the time? Can I use the culture to change the time to the client time?

You can use one of these by setting the preference of user in his/her profile. Use that set preference for showing date. — Adil, Feb 20 '15 at 04:23
@imGreg Please, refer to this: http://stackoverflow.com/questions/6525538/convert-utc-date-time-to-local-date-time-using-javascript — Augusto Barreto, Feb 20 '15 at 06:28

score 1 · Accepted Answer · answered Feb 20 '15 at 05:24

1

Your best option is to store the DateTime as UTC time and adjust it to local time (for the user's current location) each time you read it from the database.

You can use JavaScript to determine the timezone of the user:

new Date().gettimezoneOffset()

answered Feb 20 '15 at 05:24

Utsav Dawn

7,896
2
29
44

do i need the offset of saved time in the db? – imGreg Feb 20 '15 at 05:41
No there is no need for it. Just store it like this. DateTime serverDateTime = DateTime.Now; DateTime dbDateTime = serverDateTime.ToUniversalTime(); – Utsav Dawn Feb 20 '15 at 05:56

Display current datetime depending on client

1 Answers1