Subject | Question about inserting a Date and Time |
---|---|
Author | Stephen Wood |
Post date | 2003-01-07T11:30:52Z |
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]
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]