dateadd in mysql query
  • what is the equivalent of dateadd function in mysql
    as we use this query in sql server

    select DATEADD(dd,10,getdate())

    so it will add 10 days in current date so how can i do this kind of work in mysql.
  • 1 Comment sorted by
  • Vote Up0Vote Down WaqasWaqas
    172.00 Karma Accepted Answer
    use

    select DATE_ADD(now(),INTERVAL 10 DAY)

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