时间类型

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26937943/viewspace-764766/