What about:
Insert into TABLEXYZ (COLUMNXYZ)
Values ('2002.10.23 18:00:00');

The COLUMNXYZ must be timestamp type;

Luiz

----- Original Message -----
From: "Stephen Wood" <stephenw@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, January 07, 2003 9:30 AM
Subject: [ib-support] Question about inserting a Date and Time


> 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