firebird-support - RE: [ib-support] Help with TIMESTAMP field in a query

Subject	RE: [ib-support] Help with TIMESTAMP field in a query
Author	Dan Cumpian
Post date	2003-01-15T01:20:26Z

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

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

>
>
></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/