時間型別

sky850623發表於2013-06-25
型別
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章