· 8 years ago · Apr 18, 2018, 03:56 PM
1USE tempdb;
2
3DROP TABLE IF EXISTS dbo.timetest;
4
5CREATE TABLE dbo.timetest
6(
7 t datetimeoffset(7) NOT NULL
8);
9
10INSERT INTO dbo.timetest(t)
11VALUES ('2018-04-18 00:00:00 -06:00');
12
13SELECT *
14FROM dbo.timetest;