How to add 1 day to the date column in MySQL?

Share Me
  •  
  •  
  •  
  • 1
  •  
  •  
  •  
  •  
  •  
  •  
  •  
    1
    Share

Hello Devs
Welcome back again. Today in this example, i will show you how to add 1 day to the date column in MySQL. I will explain how to add days in date in mysql step by step. I explained it with you very simply about how to add 7 days to current date in mysql. In this tutorial I will give you a very simple example of add 1 day to the date column in MySQL.

So i will give you a very simple query for getting add 1 day to created_at column by using mysql function.

So let’s see example here:

Query:

Read Also : How to get last 7 days record in laravel?

SELECT 
        id, 
        name, 
        created_at,
        DATE_ADD(created_at, INTERVAL 1 DAY) AS  later_date
FROM users

Now you can try your own self.

I hope it can help you. Follow us on facebook

About Shahriar Sagor

My name is Shahriar sagor. I'm a developer. I live in Bangladesh and I love to write tutorials and tips that will help to other Developer's. I am a big fan of PHP, Javascript, JQuery, Laravel, Codeigniter, VueJS, AngularJS and Bootstrap from the early stage.

View all posts by Shahriar Sagor →

Leave a Reply

Your email address will not be published. Required fields are marked *

one × five =