getting prevoius day's date in a query?

[erebus]

could anybody help me in getting the previous day's date in a query:
In sql analyzer, the query "select getdate()-1" returns the previous day's date!
do we have a db2 equivalent of the above mentioned query.

[JBUDLARWOOD]

You could try to use Now()-1 or Date()-1.
I'm having date issues myself so I hope it works for you.

[JBUDLARWOOD]

Sorry erebus, my last reply was for use in an Access query.

[dewa81]

select (current date) - 1 days from sysibm.sysdummy 1