sqlserver如何比较两个日期(datetime)的年月大小,比较到年月,不比较日
select * from 表
where year(日期字段1)<year(日期字段2)
or
(year(日期字段1)=year(日期字段2) AND month(日期字段1)<month(日期字段2) )
eg:
select
(case when FBegQty = '0' then (case when FReceive = '0' then (case when FSend = '0' then NULL else FCredit/FSend end)else FDebit/FReceive end)else FBegBal/FBegQty end) as FPrice
,* from icinvbal
where fitemid = '6578'
and (FYear<'2012' or(FYear='2012' and FPeriod<='6'))
and (case when FBegQty = '0' then (case when FReceive = '0' then (case when FSend = '0' then NULL else FCredit/FSend end)else FDebit/FReceive end)else FBegBal/FBegQty end)is not NULL
order by fitemid, FYear, FPeriod
结果截图: