Subject | Re: [firebird-support] Time format for insertion into table |
---|---|
Author | Ivan Prenosil |
Post date | 2005-02-11T19:29:42Z |
> I'm trying to:Use 24hr format.
>
>
>
> 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.?
VALUES (7, 1, '7:00:00', '15:00:00', 'Day East CNA', 0, 'A');
Ivan