select 问题

[舍南舍北]

字段称：date
字段類型：datetime
長度：8
SELECT * FROM sales_order_detail
可以找出2005年的數據，但是 SELECT * FROM sales_order_detail where date like '2005%'
就查不到了？

[舍南舍北]

不是的哦，在執行的時候會自動加上來的，但不起作用

[feiyun0112]

因为字段類型：datetime

不是char

[舍南舍北]

SELECT * FROM sales_order_detail where date between '2005-01-01' and '2005-12-31'
这样又行啊

[faysky2]

再加一个%就行：SELECT * FROM sales_order_detail where [date] like '%2005%'

[rayxu]

select * from sales_order_detail where Year([date])=2005

[feiyun0112]

SELECT * FROM sales_order_detail where date between '2005-01-01' and '2005-12-31'
这样又行啊
--------------------------------------------
这还是日期之间比较

[cozil]

数据库会试着把你输入的字符串转换成datetime型，如果转换失败，当然不会有结果。
2005%转换成datetime肯定是无效的, '2005-01-01'转换成datetime型是 '2005-01-01 00:00:00'.
如果涉及到小时或分钟等，用dateadd()比较好。

[DengXingJie]

select * from sales_order_detail where left(convert(varchar(8),[date],111),4)='2005'

[还想懒够]

使用convert

[lionking13520]

SELECT * FROM sales_order_detail where date between '2005-01-01' and '2005-12-31'

具体的数字不能用like

[clear_zero]

推荐这个
select * from sales_order_detail where Year([date])=2005


SELECT * FROM sales_order_detail where date between '2005-01-01' and '2005-12-31'
按年查容易，如果到月份。在英美两种格式下容易出现歧义。我刚开始写程序的时候在这里遇到过困难

[vbman2003]

select *
from sales_order_detail
where convert(char(4),[date],120)='2005'

[weiweiplay]

SELECT * FROM sales_order_detail where date between '2005-01-01' and '2005-12-31'

[xtwfnwfg]

SELECT * FROM sales_order_detail Where date>='2005-01-01' and date<'2006-01-01'
最简单最直观

[xtwfnwfg]

SELECT * FROM sales_order_detail Where Year(date)=2005

[winehero]

select *
from sales_order_detail
where Year([date])=2005

[舍南舍北]

為什麼？

[faysky2]

date是关键字，必须加[]
SELECT * FROM sales_order_detail where [date] like '2005%'