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

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