RE: SQL statement in Informix 7

From: Paul Watson <PWatson@Lastminute.com> > >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 That's not true! I can't stand German beer! ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com