Results 1 to 2 of 2

Thread: getting prevoius day's date in a query?

  1. 09-26-2007, 05:18 AM #1
    erebus
    erebus is offline Registered User
    Join Date
    Sep 2007
    Posts
    1

    getting prevoius day's date in a query?

    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.
    Reply With Quote Reply With Quote
  2. 10-16-2007, 08:02 AM #2
    sss
    sss is offline Registered User
    Join Date
    Oct 2007
    Posts
    1
    to get previousDay in db2
    current timestamp-1 days
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules