· 8 years ago · Apr 18, 2018, 04:10 PM
1USE tempdb;
2
3DROP TABLE IF EXISTS dbo.timetest;
4CREATE TABLE dbo.timetest
5(
6 t datetimeoffset(7) NOT NULL
7);
8
9INSERT INTO dbo.timetest(t)
10VALUES ('2018-04-18T00:00:00Z');
11
12SELECT [Time at CEST] = t AT TIME ZONE 'Central European Standard Time'
13FROM dbo.timetest;
14
15SWITCHOFFSET