How do I convert UTC time stored in the database to user's browser timezone

Question

Using SQL Server, How can I convert the time from the database (UTC) to the user's local timezone?

Their timezone isn't stored in the database, so I have to use an external way to convert it (User's local time/browser timezone).

If anyone could help, that would be great. Thanks.

Don't try to solve this down in the database. The user isn't pointing their browser directly at a SQL Server instance - there's code running elsewhere, and that code almost certainly has better facilities for manipulating datetime data. — Damien_The_Unbeliever, Jun 13 '14 at 07:49

score 0 · Answer 1 · edited May 23 '17 at 12:05

0

I think you'll have to just convert the input into the local user's timezone before inserting it into the SQL Server.

Or maybe you could try something like this

edited May 23 '17 at 12:05

Community

answered Jun 13 '14 at 07:50

Trent

score 0 · Answer 2 · edited May 23 '17 at 10:25

0

SQL Server will be of very little help here.

If you totally don't know the exact time zone of the end user, you'll have to do client-side conversion with JavaScript:

edited May 23 '17 at 10:25

Community

answered Jun 13 '14 at 07:50

Anton Gogolev

score 0 · Answer 3 · answered Jun 13 '14 at 07:53

0

If dealing with client timezone, you need to parse date/time at the browser.

I would recommend the MomentJs library

answered Jun 13 '14 at 07:53

cloakedninjas

3 Answers3