ORACLE中函数MONTHS_BETWEEN…
来源:互联网 发布:同花顺期货软件 编辑:程序博客网 时间:2024/05/20 05:31
原文地址:ORACLE中函数MONTHS_BETWEEN的使用作者:tbqnot19
格式:MONTHS_BETWEEN(DATE1,DATE2)
MONTHS_BETWEEN函数返回两个日期之间的月份数。
SQL> select months_between(to_date('20090228','yyyymmdd'), to_date('20080228', 'yyyymmdd')) as months fromdual;
MONTHS
----------
12
SQL> select months_between(to_date('20090228','yyyymmdd'), to_date('20080229', 'yyyymmdd')) as months fromdual;
MONTHS
----------
12
SQL> select months_between(to_date('20080229','yyyymmdd'), to_date('20070228', 'yyyymmdd')) as months fromdual;
MONTHS
----------
12
SQL> select months_between(to_date('20100331','yyyymmdd'), to_date('20100228', 'yyyymmdd')) as months fromdual;
MONTHS
----------
1
SQL> select months_between(to_date('20100228','yyyymmdd'), to_date('20100128', 'yyyymmdd')) as months fromdual;
MONTHS
----------
1
SQL> select months_between(to_date('20100327','yyyymmdd'), to_date('20100228', 'yyyymmdd')) as months fromdual;
MONTHS
----------
.967741935
SQL> select months_between(to_date('20100330','yyyymmdd'), to_date('20100228', 'yyyymmdd')) as months fromdual;
MONTHS
----------
1.06451613
SQL> select months_between(to_date('20100228','yyyymmdd'), to_date('20100130', 'yyyymmdd')) as months fromdual;
MONTHS
----------
.935483871
SQL> select months_between(to_date('20100228','yyyymmdd'), to_date('20100131', 'yyyymmdd')) as months fromdual;
MONTHS
----------
1
SQL> select months_between(to_date('20100228','yyyymmdd'), to_date('20100127', 'yyyymmdd')) as months fromdual;
MONTHS
----------
1.03225806
30/31=0.96774193548387096774193548387097
33/31=1.0645161290322580645161290322581
29/31=0.93548387096774193548387096774194
32/31=1.032258064516129032258064516129
在ORACLE中计算月份的差值,都是月底或是日期相同,都会按整月计算。
如果计算结果不是整数,ORACLE会把31作为分母来计算。
MONTHS_BETWEEN函数返回两个日期之间的月份数。
SQL> select months_between(to_date('20090228','yyyymmdd'), to_date('20080228', 'yyyymmdd')) as months fromdual;
----------
SQL> select months_between(to_date('20090228','yyyymmdd'), to_date('20080229', 'yyyymmdd')) as months fromdual;
----------
SQL> select months_between(to_date('20080229','yyyymmdd'), to_date('20070228', 'yyyymmdd')) as months fromdual;
----------
SQL> select months_between(to_date('20100331','yyyymmdd'), to_date('20100228', 'yyyymmdd')) as months fromdual;
----------
SQL> select months_between(to_date('20100228','yyyymmdd'), to_date('20100128', 'yyyymmdd')) as months fromdual;
----------
SQL> select months_between(to_date('20100327','yyyymmdd'), to_date('20100228', 'yyyymmdd')) as months fromdual;
----------
.967741935
SQL> select months_between(to_date('20100330','yyyymmdd'), to_date('20100228', 'yyyymmdd')) as months fromdual;
----------
1.06451613
SQL> select months_between(to_date('20100228','yyyymmdd'), to_date('20100130', 'yyyymmdd')) as months fromdual;
----------
.935483871
SQL> select months_between(to_date('20100228','yyyymmdd'), to_date('20100131', 'yyyymmdd')) as months fromdual;
----------
SQL> select months_between(to_date('20100228','yyyymmdd'), to_date('20100127', 'yyyymmdd')) as months fromdual;
----------
1.03225806
30/31=0.967741935483870967741935
33/31=1.064516129032258064516129
29/31=0.935483870967741935483870
32/31=1.032258064516129032258064
在ORACLE中计算月份的差值,都是月底或是日期相同,都会按整月计算。
如果计算结果不是整数,ORACLE会把31作为分母来计算。
0 0
- ORACLE中函数MONTHS_BETWEEN…
- ORACLE 日期函数 MONTHS_BETWEEN
- ORACLE 日期函数 MONTHS_BETWEEN
- ORACLE 日期函数 MONTHS_BETWEEN
- oracle 日期函数 MONTHS_BETWEEN
- oracle--months_between函数
- oracle中months_between说明
- Oracle months_between()和add_months()函数
- oracle字符串连接及months_between函数
- Oracle日期函数months_between的用法
- Oracle MONTHS_BETWEEN
- MONTHS_BETWEEN函数
- MONTHS_BETWEEN函数
- Oracle的months_between(date1,date2)函数注意点
- 日期函数 MONTHS_BETWEEN
- 日期函数 MONTHS_BETWEEN
- months_between
- 日期函数months_between的用法
- Retrieving the COM&nbs…
- Python之time模块
- win7 64位DCOM配置(关于导出…
- ASP.NET DataTextFormatStri…
- oracle 查询返回多行合成一行
- ORACLE中函数MONTHS_BETWEEN…
- C#求100以内的质数
- PHP的AES加密
- asp.net登陆时候记住用户名密码
- Kingbase金仓更改表空间
- oracle 数据库函数
- easyui 的datagrid合并行或者列
- System.Data.OracleClient需要Orac…
- 关于数据库获取前几行不同数据库的…