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