Re: SQL statement in Informix 7

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