22,209
社区成员
发帖
与我相关
我的任务
分享
DECLARE @t TABLE (chk_time VARCHAR(20))
INSERT INTO @t VALUES ('2017-11-06')
SELECT
CAST(chk_time AS DATE) AS chk_time
FROM @t t
WHERE
chk_time
BETWEEN DATEADD(dd,-2,CAST('2017-11-06 00:06:57' AS date))
AND
CAST('2017-11-06 00:06:57' AS DATE)
直接用你的代码, 没什么问题呀