By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,222 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

getting prevoius day's date in a query?

P: 6
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.
Sep 26 '07 #1
Share this Question
Share on Google+
3 Replies

P: 32
You could try to use Now()-1 or Date()-1.
I'm having date issues myself so I hope it works for you.
Sep 26 '07 #2

P: 32
Sorry erebus, my last reply was for use in an Access query.
Sep 26 '07 #3

P: 14
select (current date) - 1 days from sysibm.sysdummy1
Sep 26 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.