The mistake is you specified PM also in the query.
But the timestamp field will take the time from 01 to 24.
If you remove PM in your query,it will work fine.

Sivaraman


---------- 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@....