Re: SQL statement in Informix 7
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
:-p
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com