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.

TAGS
MySql

4.5/5.0
Last updated 08 September, 2022
By Admin

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...

Database

MySql

How To Add 1 Day To The Date Column In MySQL?

Query:

Output

Categories

Popular Tags