ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 时间类型

时间类型

原创 Linux操作系统 作者:sky850623 时间:2013-06-25 12:39:19 0 删除 编辑
1.interval year to month
 
INTERVAL YEAR [(year_precision)] TO MONTH
默认值为2

SQL> create table coupons(
  2  coupon_id integer,
  3  name varchar2(30),
  4  duration interval year(3) to month
  5  );
Table created.
SQL> insert into coupons values(1,'A',interval '1' year);
1 row created.
SQL> insert into coupons values(2,'B',interval '11' month);
1 row created.
SQL> insert into coupons values(3,'C',interval '1-3' year to month);
1 row created.
SQL> insert into coupons values(4,'D',interval '0-5' year to month);
1 row created.
SQL> insert into coupons values(5,'E',interval '123' year(3));
1 row created.
SQL> select * from coupons;
 COUPON_ID NAME                           DURATION
---------- ------------------------------ ---------------------
         1 A                              +001-00
         2 B                              +000-11
         3 C                              +001-03
         4 D                              +000-05
         5 E                              +123-00
2.interval day to second
 
INTERVAL DAY [(day_precision)]
   TO SECOND [(fractional_seconds_precision)]
day_precision: 0-9  默认为2
fractional_seconds_precision: 0-9  默认为6

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26937943/viewspace-764766/,如需转载,请注明出处,否则将追究法律责任。

上一篇: oracle schema对象
下一篇: 存储过程
请登录后发表评论 登录
全部评论

注册时间:2013-05-30

  • 博文量
    154
  • 访问量
    466823