Thanks for the help...

Dan


-----Original Message-----
From: Sivaraman Krishnan [mailto:sivaraman@...]
Sent: Tuesday, January 14, 2003 12:35 AM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Help with TIMESTAMP field in a query

Instead of '1/3/2002 7:00:00 PM' you write
'1/3/2002 19:00:00', it will work fine.

Sivaraman
Software Associates Information TEchnology,
Calicut,
India


---------- Original Message ----------------------------------
From: "Dan Cumpian" <ir000387@...>
Reply-To: ib-support@yahoogroups.com
Date: Mon, 13 Jan 2003 18:37:40 -0500

><html><body>
>
>
><tt>
>Hello,<BR>
><BR>
> <BR>
><BR>
>I have the following query that fails with a "conversion error from<BR>
>string":<BR>
><BR>
> <BR>
><BR>
>delete from messages where daterecvd < '1/3/2002 7:00:00 PM'<BR>
><BR>
> <BR>
><BR>
>The field daterecvd is a TIMESTAMP field. What am I doing wrong?<BR>
><BR>
> <BR>
><BR>
>Thank you,<BR>
><BR>
>Dan Cumpian<BR>
><BR>
> <BR>
><BR>
><BR>
><BR>
>[Non-text portions of this message have been removed]<BR>
><BR>
></tt>
>
>
><br>
><tt>
>To unsubscribe from this group, send an email to:<BR>
>ib-support-unsubscribe@egroups.com<BR>
><BR>
></tt>
><br>
>
><br>
><tt>Your use of Yahoo! Groups is subject to the <a

href="http://docs.yahoo.com/info/terms/">Yahoo! Terms of
Service</a>.</tt>

></br>
>
></body></html>
>
>

________________________________________________________________
Sent via the email service at softwareassociates.co.uk
Operated by Oceanbase.com. Contact info@....




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



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/