Oracle 年月比较

Posted on 2005-08-23 16:26 HQT 阅读(1136) 评论(0) 编辑收藏举报

select distinct(dateColumn) from table where trunc(to_char(to_date('2005-8-1','yyyy-mm-dd'),'yyyymm')-to_char(dateColumn,'yyyymm'))=0

select distinct(dateColumn) from table where trunc(to_char(to_date('2005-8-1','yyyy-mm-dd'),'yyyy')-to_char(dateColumn,'yyyy'))=0