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? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com