How to convert datetime to UTC in sql

Question

Does any one know how can I convert datetime to UTC in sql?

Example: If I have a datetime variable @test = '2014-09-09 9:00:00', how can I convert @test into UTC in SQL?

Is this a general sql question? Or is it for any specific RDMS (oracle,mysql,mssql)? — Arion, Sep 11 '14 at 06:07
If MSSQL - http://stackoverflow.com/questions/18460562/convert-datetime-to-utc-value-mssql — ashokhein, Sep 11 '14 at 06:11

score 0 · Accepted Answer · answered Sep 11 '14 at 08:39

0

Please try below Query in SQL Server :

Declare @test as datetime
set @test = '2014-09-09 9:00:00'
SELECT DATEADD(second, DATEDIFF(second, GETDATE(), GETUTCDATE()), @test)

answered Sep 11 '14 at 08:39

Navneet

3

This does not take daylight savings into account. See the many other SO posts about daylight savings and UTC. – Alien Technology Apr 24 '17 at 14:53

1 Answers1