how to subtract days from current date in sql server
  • how to subtract days from current date in sql server kindly provide query.
  • 1 Comment sorted by
  • Vote Up0Vote Down WaqasWaqas
    172.00 Karma Accepted Answer
    There are different method for this i providing two queries for subtract days from date.


    select GETDATE()-1

    and
    select DateAdd(dd, -1, Getdate())

Howdy, Stranger!

It looks like you're new here. If you want to get involved, or you want to Ask a new Question, Please Login or Create a new Account by Clicking below

Login with Facebook

Tagged

Popular Posts of the Week

Top Posters Weekly

Optimum Creative