表一中有
字段为:
bookName madeDate
-----------------
a 2002-08-08
我写成 select * from bookInfo where madeDate>2010-6-6 数据能够显示(非期望结果)
但写成 select * from bookInfo where madeDate>'2010-6-6' 数据就没显示(期望的结果)
希望大家帮我解释下原因,谢谢~~~~~~~~~~~~
...全文
15211打赏收藏
问一个基础问题,大家帮忙解释下,先谢了
表一中有 字段为: bookName madeDate ----------------- a 2002-08-08 我写成 select * from bookInfo where madeDate>2010-6-6 数据能够显示(非期望结果) 但写成 select * from bookInfo where madeDate>'2010-6-6' 数据就没显示(期望的结果) 希望大家帮我解释下原因,谢谢~~~~~~~~~~~~
select * from dbo.Orders where orderdate>1996-7-4 order by orderdate
select * from dbo.Orders where orderdate>'1996-7-4' order by orderdate
--正确的
select * from dbo.Orders where orderdate>'1996-07-04' order by orderdate
--相当于
select * from dbo.Orders where orderdate>'1996-07-04 00:00:00.000' order by orderdate