这句话有错吗,整了我几个小时了

select * from qiushu where sn=2 and ft=1 and kaitimies= #"2003-3-15"# order by kaitimes desc
kaitimes在sql数据裤中是datetime格式 里面有2003-3-15 23:00:00

用查询分析器才老是说
服务器: 消息 170,级别 15,状态 1,行 1
第 1 行: '2003-3-15' 附近有语法错误。

---------------------------------------------------------------

没有满足条件的记录:)
---------------------------------------------------------------

呵呵,这个问题说来话长。sql server中的datetime类型是保存了时间的,即使你只写进日期(以12:00填充)。所以
select * from qiushu where sn=2 and ft=1 and kaitimies= '2003-3-15' order by kaitimes desc
等价于
select * from qiushu where sn=2 and ft=1 and kaitimies= '2003-3-15 12:00' order by kaitimes desc
要取出该天的记录,应该这样
select * from qiushu where sn=2 and ft=1 and kaitimies>='2003-3-15' and kaitimies<='2003-3-16' order by kaitimes desc

Published At
Categories with Web编程
Tagged with
comments powered by Disqus