27,579
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM t
WHERE observeDate BETWEEN '2013-01-01' AND '2013-12-31'
col between v1 and v2 , 想当于 col >= v1 and col <= v2 。
SELECT * FROM Table t
WHERE CONVERT(varchar(5), t.observeDate, 110) BETWEEN '03-05' AND '03-06'