标题: 查询2012.12－2013.4的数据，SQL应该怎么写？ [打印本页] 作者: 站长苏飞 时间: 2013-4-11 13:59 标题: 查询2012.12－2013.4的数据，SQL应该怎么写？ 先看看我写的语法吧
[code=sql]SELECT * FROM table WHERE createtime>=st AND createtime<=et
SELECT * FROM table WHERE createtime BETWEEN st AND et[/code]
这样就行了
[code=sql]SELECT * FROM table WHERE createtime>=‘2012.12’ AND createtime<=‘2013.4’
SELECT * FROM table WHERE createtime BETWEEN ‘2012.12’ AND ‘2013.4’[/code]
但是人家说只精确到月好吧我再修改下
[code=sql]SELECT * FROM table WHERE createtime>=CONVERT(VARCHAR(7), st, 121) AND createtime<=CONVERT(VARCHAR(7), et, 121)
SELECT * FROM table WHERE createtime BETWEEN CONVERT(VARCHAR(7), st, 121) AND CONVERT(VARCHAR(7), et, 121)[/code]