在SQL Server中，數(shù)據(jù)類型datetimeoffset轉(zhuǎn)換為datetime類型或datetime2類型時(shí)需要特別注意，有可能一不小心你可能會(huì)碰到下面這種情況。下面我們構(gòu)造一個(gè)簡(jiǎn)單案例，模擬一下你們可能遇到的情況。

CREATE TABLE TEST
(
ID INT IDENTITY(1,1)
,CREATE_TIME DATETIME
,CONSTRAINT PK_TEST PRIMARY KEY(ID)

);
GO

INSERT INTO TEST(CREATE_TIME)
SELECT ‘2020-10-03 11:10:36’ UNION ALL
SELECT ‘2020-10-03 11:11:36’ UNION ALL
SELECT ‘2020-10-03 11:12:36’ UNION ALL
SELECT ‘2020-10-03 11:13:36′;

DECLARE @p1 DATETIMEOFFSET;
SET @p1=’2020-10-03 11:12:36.9200000 +08:00’
SELECT * FROM dbo.TEST
WHERE CREATE_TIME <=@p1;