完全是可以的 比如select * from xxx where year(riqi)='2009'只要后面的条件是一个表达式就可以了当然还可以更复杂
select * from xxx where riqi between '2009-1-1' and '2009-12-31'
