Thanks guys for the quick response....

That was the problem, the column was defined as DATE.....


-----Original Message-----
From: Svein Erling Tysvaer [mailto:svein.erling.tysvaer@...]
Sent: 07 January 2003 13:54
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Question about inserting a Date and Time

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

Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/M=241773.2725424.4169802.1925585/D=egroupweb/S=17051153
86:HM/A=1394046/R=0/*http:/www.hgtv.com/hgtv/pac_ctnt/text/0,,HGTV_3936_5802
,FF.html> HGTV Dream Home Giveaway


<http://us.adserver.yahoo.com/l?M=241773.2725424.4169802.1925585/D=egroupmai
l/S=:HM/A=1394046/rand=797024669>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.


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