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.

values (current date - 1 day)

Or "select current_date - 1 day from sysibm.sysdummy1"

Hi,
interesting. There are two choses current date or current_date. I recommend using current_date because it is a standard SQL.
Hope this helps,
Grofaty