INTERVAL的使用
来源:互联网 发布:php数组排序算法 编辑:程序博客网 时间:2024/04/30 13:21
INTERVAL可以用来做时间的加减法:
SELECT INTERVAL '300' MONTH "25年",
INTERVAL '54-2' YEAR TO MONTH "54年2个月",
INTERVAL '11:12:10.1234567' hour TO SECOND "小时到秒"
FROM dual;
语法:
INTERVAL '{ integer | integer time_expr | time_expr }'
{ { DAY | HOUR | MINUTE } [ ( leading_precision ) ]
| SECOND [ ( leading_precision [, fractional_seconds_precision ] ) ] }
[ TO { DAY | HOUR | MINUTE | SECOND [ (fractional_seconds_precision) ] } ]
示例:
SQL> select date '2010-01-01' + interval '21' year from dual;
DATE'2010-01-01'+INTERVAL'21'Y
------------------------------
2031-01-01
SQL> select date '2010-01-01' + interval '123-2' year(4) to month from dual;
DATE'2010-01-01'+INTERVAL'123-
------------------------------
2133-03-01
SQL> select date '2010-01-01' + interval '100' month from dual;
DATE'2010-01-01'+INTERVAL'100'
------------------------------
2018-05-01
SQL> select date '2010-01-01' + interval '100' day(2) from dual;
select date '2010-01-01' + interval '100' day(2) from dual
ORA-01873: the leading precision of the interval is too small --这里应该是day(3) 因为interval之后的100是三位数,默认是2位数
SQL> select date '2010-01-01' + interval '1 2' day to hour from dual;
DATE'2010-01-01'+INTERVAL'12'D
------------------------------
2010-01-02 02:00:00
SQL> select date '2010-01-01' + interval '1 2:3' day to minute from dual;
DATE'2010-01-01'+INTERVAL'12:3
------------------------------
2010-01-02 02:03:00
SQL> select date '2010-01-01' + interval '1 2:3:4' day to second from dual;
DATE'2010-01-01'+INTERVAL'12:3
------------------------------
2010-01-02 02:03:04
SQL> select date '2010-01-01' + interval '1' hour from dual;
DATE'2010-01-01'+INTERVAL'1'HO
------------------------------
2010-01-01 01:00:00
SQL> select date '2010-01-01' + interval '1:2' hour to minute from dual;
DATE'2010-01-01'+INTERVAL'1:2'
------------------------------
2010-01-01 01:02:00
SQL> select date '2010-01-01' + interval '1:2:3' hour to second from dual;
DATE'2010-01-01'+INTERVAL'1:2:
------------------------------
2010-01-01 01:02:03
SQL> select date '2010-01-01' + interval '1:2' minute to second from dual;
DATE'2010-01-01'+INTERVAL'1:2'
------------------------------
2010-01-01 00:01:02
0 0
- INTERVAL的使用
- interval使用的一些例子
- Oracle INTERVAL(INTERVAL DAY TO SECOND,INTERVAL YEAR TO MONTH)数据类型的使用
- 57. Insert Interval , STL的使用
- SQL :datetime和interval数据类型的使用, 备查
- 一个由于错误使用interval导致的错误
- 1Z0-51 QUESTION 22 INTERVAL的使用
- AngularJS监听页面关闭,定时器$interval()的使用
- Interval的知识点
- interval
- INTERVAL
- interval
- 校门外的区间(interval)
- SQL SERVER的recovery interval
- 无线路由的beacon interval
- add_months 和interval 的区别
- QUESTION 19 INTERVAL的用法
- UsageStatsManager.queryUsageStats的参数interval
- 启示录
- Android自定义listview及其点击事件监听
- 腾讯大数据之MapReduce
- hbase部署实践
- 1077:美丽数【JAVA实现】
- INTERVAL的使用
- 新起点新开始
- Activity界面跳转
- B树、B-树、B+树、B*树
- C语言小试牛刀两个初级程序练习------1到100的加法运算,两个数大小的比较
- 如何防止头文件被重复包含、嵌套包含
- 网页布局基础的学习笔记
- Product Quantization of high dimensional vector
- C#的Attribute特性简介