Subject Question about inserting a Date and Time
Author Stephen Wood
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



[Non-text portions of this message have been removed]