At 01:30 PM 7/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

Insert into TABLEXYZ (COLUMNXYZ)
Values (CAST('23-OCT-2002 18:00:00' AS TIMESTAMP));

heLen