datetime日期类型如何比较

[sidney]

select sum(amount)from tbMeterOperation where fdDateTime >'2008'
and fdDateTime <'2009'
这句查询返回NULL，如果把and去掉可以查询，请问，怎么实现查询2008年的总额？
实际存储的日期如下：2009-08-25 14:29:00.000

[水族杰纶]

select sum(amount)from tbMeterOperation where datepart(fdDateTime)
between 2008 and 2009 

[feixianxxx]

select *
from tb 
where datepart(year,fdDateTime)=2008

[lihan6415151528]

select sum(amount)from tbMeterOperation where datepart(yy,fdDateTime )=2008

[feixianxxx]

select sum(amount) from tbMeterOperation 
where datepart(year,fdDateTime)=2008

[水族杰纶]

[Quote=引用 1 楼 wufeng4552 的回复:]
SQL codeselectsum(amount)from tbMeterOperationwheredatepart(fdDateTime)between2008and2009
[/Quote]

--少了參數
select sum(amount)from tbMeterOperation where datepart(yy,fdDateTime)
between 2008 and 2009 

[dawugui]

select sum(amount)from tbMeterOperation where datepart(yy,fdDateTime) between 2008 and 2009

[--小F--]

--try
select 
  sum(amount)
from 
  tbMeterOperation 
where 
  convert(varchar(10),fdDateTime,120) between '2008-01-01' and '2008-12-31' 

[SQL77]

select sum(amount)from tbMeterOperation where 
DATEDIFF(YY,GETDATE(),fdDateTime )=0 
OR
DATEDIFF(YY,GETDATE(),fdDateTime )-1=0

[--小F--]

或者
select 
  sum(amount)
from 
  tbMeterOperation 
where 
  datepart(yy,fdDateTime )=2008

或者
select 
  sum(amount)
from 
  tbMeterOperation 
where 
  datepart(yy,fdDateTime) between 2008 and 2009