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

In this example, i will show you mysql add 1 day to timestamp. step by step explain how to add days in date in mysql. i explained simply about how to add 7 days to current date in mysql. This tutorial will give you simple example of mysql add day to date.

I will give you simple query to getting add 1 day to created_at column using mysql function. let's see example here:

Query:

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

Output:

I hope it can help you...