Thanks, that did the trick.

I must admit it seems rather odd to me that you insert the value as
'15:00:00' and it is displayed from the DB as '3:00:00 PM'--why not display
it as it was entered?

Clay Shannon,
Dimension 4 Software

-----Original Message-----
From: Ivan Prenosil [mailto:Ivan.Prenosil@...]
Sent: Friday, February 11, 2005 1:30 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Time format for insertion into table

> 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



Yahoo! Groups Links