- CREATE TABLE INTERVAL_TBL (f1 interval);
- INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 1 minute');
- INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 5 hour');
- INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 10 day');
- INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 34 year');
- INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 3 months');
- INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 14 seconds ago');
- INSERT INTO INTERVAL_TBL (f1) VALUES ('1 day 2 hours 3 minutes 4 seconds');
- INSERT INTO INTERVAL_TBL (f1) VALUES ('6 years');
- INSERT INTO INTERVAL_TBL (f1) VALUES ('5 months');
- INSERT INTO INTERVAL_TBL (f1) VALUES ('5 months 12 hours');
|