| Subject | Re: [ib-support] Help with TIMESTAMP field in a query |
|---|---|
| Author | Sivaraman Krishnan |
| Post date | 2003-01-14T05:34:58Z |
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
Sent via the email service at softwareassociates.co.uk
Operated by Oceanbase.com. Contact info@....
'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@....