pl/sql中怎么判断两个日期在同一个月内？

Question

to_char(date1,'mm')=to_char(date2,'mm')=0

Answer 1

sorry:
to_char(date1,'mm')=to_char(date2,'mm')

Answer 2

掺和：
to_char(date1,'yyyymm')=to_char(date2,'yyyymm')

Answer 3

ABS(MONTHS_BETWEEN(D1,D2))<1 and to_char(d1,'yyyymm')=to_char(d2,'yyyymm')

Answer 4

楼上，不用这么多条件
to_char(d1,'yyyymm')=to_char(d2,'yyyymm')另
select months_between(to_date('20030518','yyyymmdd'),
to_date('20030430','yyyymmdd')) from dual
MONTHS_BETWEEN(TO_DATE('20030518','YYYYMMDD'),TO_DATE('20030430','YYYYMMDD'))
-----------------------------------------------------------------------------
                                                                   .612903226
不行

Answer 5

to 楼上：truncate一下即可。