Subject Re: [firebird-support] Time format for insertion into table
Author Ivan Prenosil
> I'm trying to:
>
>
>
> INSERT INTO SCHEDPOSITIONS
>
> VALUES (7, 1, '7:00:00 AM', '3:00:00 PM', 'Day East CNA', 0, 'A');
>
>
>
> But get "conversion error from string" on the '7:00:00 AM' value. This
> column is of TIME type. Do I need to cast it, or.?

Use 24hr format.

VALUES (7, 1, '7:00:00', '15:00:00', 'Day East CNA', 0, 'A');

Ivan