SQL statement in Informix 7

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