日期型数匹配查询,“%”只对字符型数据匹配,不可直接进行匹配查询,必须进行转换。
代码如下:
select * from table where ((rtrim(cast(year(date) as varchar)) like '2007%') and (rtrim(cast(month(date) as varchar)) like '%'))
代码如下:
select * from table where ((rtrim(cast(year(date) as varchar)) like '2007%') and (rtrim(cast(month(date) as varchar)) like '%'))