oracle中时间两个月差,如何求两个日期相差月数和天数

最初由 shiguibao 发布

[B]elect trunc(months_between(to_date('20060915','yyyymmdd'),to_date('20060326','yyyymmdd')))||'月'

||trunc((months_between(to_date('20060915','yyyymmdd'),to_date('20060326','yyyymmdd')) -

trunc(months_between(to_date('20060915','yyyymmdd'),to_date('20060326','yyyymmdd'))))*30)||'天' time_long from dual;

TIME_LONG

---------

5月19天 [/B]

有点瑕疵，有误差

请看

[PHP]

SQL> select trunc(months_between(to_date('20060330','yyyymmdd'),to_date('20060228','yyyymmdd')))||'月'

||trunc((months_between(to_date('20060330','yyyymmdd'),to_date('20060228','yyyymmdd')) -

trunc(months_between(to_date('20060330','yyyymmdd'),to_date('20060228','yyyymmdd'))))*30)||'天' time_long from dual;

TIME_LONG

---------

1月1天

SQL> select trunc(months_between(to_date('20060329','yyyymmdd'),to_date('20060228','yyyymmdd')))||'月'

||trunc((months_between(to_date('20060329','yyyymmdd'),to_date('20060228','yyyymmdd')) -

trunc(months_between(to_date('20060329','yyyymmdd'),to_date('20060228','yyyymmdd'))))*30)||'天' time_long from dual;

TIME_LONG

---------

1月0天

SQL> select trunc(months_between(to_date('20060328','yyyymmdd'),to_date('20060228','yyyymmdd')))||'月'

||trunc((months_between(to_date('20060328','yyyymmdd'),to_date('20060228','yyyymmdd')) -

trunc(months_between(to_date('20060328','yyyymmdd'),to_date('20060228','yyyymmdd'))))*30)||'天' time_long from dual;

TIME_LONG

---------

1月0天

SQL> select trunc(months_between(to_date('20060330','yyyymmdd'),to_date('20060228','yyyymmdd')))||'月'

||trunc((months_between(to_date('20060330','yyyymmdd'),to_date('20060228','yyyymmdd')) -

trunc(months_between(to_date('20060330','yyyymmdd'),to_date('20060228','yyyymmdd'))))*30)||'天' time_long from dual;

TIME_LONG

---------

1月1天

SQL> select trunc(months_between(to_date('20060327','yyyymmdd'),to_date('20060228','yyyymmdd')))||'月'

||trunc((months_between(to_date('20060327','yyyymmdd'),to_date('20060228','yyyymmdd')) -

trunc(months_between(to_date('20060327','yyyymmdd'),to_date('20060228','yyyymmdd'))))*30)||'天' time_long from dual;

TIME_LONG

---------

0月29天

SQL> select trunc(months_between(to_date('20060331','yyyymmdd'),to_date('20060228','yyyymmdd')))||'月'

||trunc((months_between(to_date('20060331','yyyymmdd'),to_date('20060228','yyyymmdd')) -

trunc(months_between(to_date('20060331','yyyymmdd'),to_date('20060228','yyyymmdd'))))*30)||'天' time_long from dual;

TIME_LONG

---------

1月0天

....................................................................................................................

[/PHP]