select * from table_name where months_between(sysdate,to_date('2004-03-04','yyyy-mm-dd'))>1
select * from table_name where months_between(sysdate,to_date('2004-03-04','yyyy-mm-dd'))>1给解释一下 where months_between(sysdate,to_date('2004-03-04','yyyy-mm-dd'))>1
where months_between(sysdate,to_date('2004-03-04','yyyy-mm-dd'))>1
where months_between(sysdate,to_date('2004-03-04','yyyy-mm-dd'))>1给解释一下
where months_between(sysdate,to_date('2004-03-04','yyyy-mm-dd'))>1
是不是大于另一字段值(值为天数)可以写为:
select * from table_name
where months_between(sysdate,to_date('2004-03-04','yyyy-mm-dd')) > limitedDays
where dt1-dt2>30;
where to_char(Date1,'yyyy/mm/dd')-to_char(Date2,'yyyy/mm/dd')>30;