Turbo SQL offers two different notations for time literals. The native format expects time literals to be in the format HH:mm; where hh are the hours and mm the minutes. Turbo SQL uses the 24 hour scale, that is 2:10 is in the early morning (2:10 AM) while 14:10 is in the early afternoon (2:10 PM). The time literal must not be enclosed in quotation marks.
INSERT INTO WorkOrder
(ID, StartTime)
VALUES ("B00120", 22:30)
If you prefer, you can enter the time value in the American format hh.mm.ss am/pm. In order to do this, you must enclose the time literal in double quotes:
INSERT INTO WorkOrder
(ID, StartTime)
VALUES ("B00120", "10.30 pm")