Mega Code Archive

 

Categories / MSSQL / Date Timezone

 

Difference between the current time and UTC

1> -- Difference between the current time and UTC 2> 3> SELECT DATEDIFF(hour, GETDATE(), GETUTCDATE()) 4> GO -----------           7 (1 rows affected) 1> 2>