INTERVAL DATATYPE

CREATE TABLE coupons (
coupon_id INTEGER,
name VARCHAR2(30),
duration INTERVAL YEAR(3) TO MONTH
);


INSERT INTO coupons (coupon_id, name, duration) VALUES (1, '$1 off Z Files', INTERVAL '1' YEAR);
INSERT INTO coupons (coupon_id, name, duration) VALUES (2, '$2 off Pop 3', INTERVAL '11' MONTH);
INSERT INTO coupons (coupon_id, name, duration) VALUES (3, '$3 off Modern Science', INTERVAL '14' MONTH);
INSERT INTO coupons (coupon_id, name, duration) VALUES (4, '$2 off Tank War', INTERVAL '1-3' YEAR TO MONTH);
INSERT INTO coupons (coupon_id, name, duration) VALUES (5, '$1 off Chemistry', INTERVAL '0-5' YEAR TO MONTH);
INSERT INTO coupons (coupon_id, name, duration) VALUES (6, '$2 off Creative Yell', INTERVAL '123' YEAR(3));

SELECT * FROM coupons;

-----------------------------------------------------------------
CREATE TABLE promotions (
promotion_id INTEGER,
name VARCHAR2(30),
duration INTERVAL DAY(3) TO SECOND (4));



INSERT INTO promotions (promotion_id, name, duration)
VALUES (1, '10% off Z Files', INTERVAL '3' DAY);

INSERT INTO promotions (promotion_id, name, duration)
VALUES (2, '20% off Pop 3', INTERVAL '2' HOUR);

INSERT INTO promotions (promotion_id, name, duration)
VALUES (3, '30% off Modern Science', INTERVAL '25' MINUTE);


INSERT INTO promotions (promotion_id, name, duration)
VALUES (4, '20% off Tank War', INTERVAL '45' SECOND);

INSERT INTO promotions (promotion_id, name, duration)
VALUES (5, '10% off Chemistry', INTERVAL '3 2:25' DAY TO MINUTE);

INSERT INTO promotions (promotion_id, name, duration)
VALUES (6, '20% off Creative Yell',INTERVAL '3 2:25:45' DAY TO SECOND);

INSERT INTO promotions (promotion_id, name, duration)
VALUES (7, '15% off My Front Line',
INTERVAL '123dd 2:25:45.12' DAY(3) TO SECOND(2));



SELECT * FROM promotions;