Re: SQL statement in Informix 7

Try something like "Select * from .... where row_date=current -1" Regards, Nick Draper Tessella Support Services In article <BMEG4.5210$74.83632@newsc.telia.net>, "Mattias Johansson" <mattias.johansson@teleopti.se> wrote: > Hello! > > 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())" > > -- > -------------------------------------------------------------- > > Teleoptimering AB > > J'rnv'gsgatan 2, 645 31 Str'ngn's > > Phone: +46 152 124 76 > > Cell:+46 (0)709 54 49 06 fax:+46 8 544 90 560 > > e-mail: mattias.johansson@teleopti.se Internet: www.teleopti.se > > Sent via Deja.com http://www.deja.com/ Before you buy.

nicholas_draper@my-deja.com wrote: > Try something like > "Select * from .... where row_date=current -1" You can use TODAY - 1 or CURRENT YEAR TO DAY - 1 UNITS DAY > "Mattias Johansson" <mattias.johansson@teleopti.se> wrote: > > 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())" -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN #include <disclaimer.h>