Re: SQL statement in Informix 7

From: "Anne Shelp" <shean@mcdss.co.gov> > > >>>> "Obnoxio The Clown" <obnoxio@hotmail.com> 04/05/00 02:10PM >>> > >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? > >Yes, I am sure. Whether you can read it or not.... Jim? How you've changed... ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com