Re: SQL statement in Informix 7

--Boundary_(ID_K2pMJQP+xJhhgMe9xW/tsg) Content-type: text/plain; charset=us-ascii Content-disposition: inline Content-transfer-encoding: 7BIT Mattias Try "Select * from .... where row_date=today -1 " HTH Sujit Mattias Johansson <mattias.johansson@teleopti.se> on 04/05/2000 03:42:41 AM Please respond to Mattias Johansson <mattias.johansson@teleopti.se> To: informix-list@iiug.org cc: Subject: SQL statement in Informix 7 --Boundary_(ID_K2pMJQP+xJhhgMe9xW/tsg) Content-type: text/plain; charset=iso-8859-1 Content-disposition: inline Content-transfer-encoding: quoted-printable Hello! How do I select values from Informix database one day back in time? "Select * from .... where row_date=3D???" In SQL Server I can write: "Select * from .... where row_date=3D dateadd(day,-1,getdate())" -- -------------------------------------------------------------- Teleoptimering AB J=E4rnv=E4gsgatan 2, 645 31 Str=E4ngn=E4s 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 = --Boundary_(ID_K2pMJQP+xJhhgMe9xW/tsg)--