RE: SQL statement in Informix 7
From: "jim lowry" <lowryjim@hotmail.com>
>
>>From: "Obnoxio The Clown" <obnoxio@hotmail.com>
>>To: mattias.johansson@teleopti.se, informix-list@iiug.org
>>Subject: Re: SQL statement in Informix 7
>>Date: Wed, 05 Apr 2000 12:40:03 BST
>>
>>From: "Mattias Johansson" <mattias.johansson@teleopti.se>
>>>
>>>How do I select values from Informix database
>>>one day back in time?
>>>
>>>"Select * from .... where row_date=???"
>>>
>>>In SQL Server I can write:
>>>
>>>"Select * from .... where row_date= dateadd(day,-1,getdate())"
>>
>>In Informix I can write:
>>
>>Select * from .... where row_date= TODAY -1>>
>In the dark I can write,
>
>But you can't be sure, can you?
Hmmm, old Heisenberg again
Paul Watson #
WFSoftware Ltd # All answers given
Tel: +44 1436 674729 # are pure fantasy
Fax: +44 1436 678693 #
www.wfsoftware.com/informix #