interval_tbl.sql 599 B

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