- CREATE TABLE TIME_TBL (f1 time(2));
- INSERT INTO TIME_TBL VALUES ('00:00');
- INSERT INTO TIME_TBL VALUES ('01:00');
- INSERT INTO TIME_TBL VALUES ('02:03'); --INSERT INTO TIME_TBL VALUES ('02:03 PST');
- INSERT INTO TIME_TBL VALUES ('11:59'); --INSERT INTO TIME_TBL VALUES ('11:59 EDT');
- INSERT INTO TIME_TBL VALUES ('12:00');
- INSERT INTO TIME_TBL VALUES ('12:01');
- INSERT INTO TIME_TBL VALUES ('23:59');
- INSERT INTO TIME_TBL VALUES ('11:59:59.99 PM');
- INSERT INTO TIME_TBL VALUES ('2003-03-07 15:36:39'); -- INSERT INTO TIME_TBL VALUES ('2003-03-07 15:36:39 America/New_York');
- INSERT INTO TIME_TBL VALUES ('2003-07-07 15:36:39'); -- INSERT INTO TIME_TBL VALUES ('2003-07-07 15:36:39 America/New_York');
|