ORACLE中函数MONTHS_BETWEEN的使用 代码语言:javascript 复制 格式:MONTHS_BETWEEN(DATE1,DATE2)MONTHS_BETWEEN函数返回两个日期之间的月份数。SQL>selectmonths_between(to_date('20090228','yyyymmdd'),to_date('20080228','yyyymmdd'))asmonths from dual;MONTHS---12SQL>selectmonths_between(to_date('20090228',...
大家好,又见面了,我是你们的朋友全栈君。...ORACLE中函数MONTHS_BETWEEN的使用格式:MONTHS_BETWEEN(DATE1,DATE2) MONTHS_BETWEEN函数返回两个日期之间的月份数。...1.0645161290322580645161290322581 29/31=0.9354...