Re: SQL statement in Informix 7

Posted in 2000

jim lowry — Wed, 05 Apr 2000 05:15:36 PDT — source: Informix-list mailing list archive (1991-1998)

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