RE: SQL statement in Informix 7
TRY:
select * from ..... where row_date = today -1;
Wayne E. Martin
Informix Database Administrator
Kmart Corp.
-----Original Message-----
From: Mattias Johansson [mailto:mattias.johansson@teleopti.se]
Sent: Wednesday, April 05, 2000 6:43 AM
To: informix-list@iiug.org
Subject: 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