Steve,
how did you define the column? From IB6 onwards a column defined as Date
only contains a date, if you want the time as well you have to define it as
TimeStamp.

Set

At 13:30 07.01.2003 +0200, you wrote:

>Hi guys,
>
>I'm having a little problem getting the format correct to insert a date and
>time into a column, can anyone tell me what the format is because I can't
>seem to find it in the Firebird documentation....for example, I'm trying...
>
>Insert into TABLEXYZ (COLUMNXYZ)
>Values ('23-OCT-2002 18:00:00');
>
>And all other variations I've tried throw a conversion error every time....
>
>Thanks
>Steve