Collections:
Incrementing a Date by 1 in MySQL
How To Increment Dates by 1 in MySQL?
✍: FYIcenter.com
If you have a date, and you want to increment it by 1 day, you can use the DATE_ADD(date, INTERVAL 1 DAY) function. You can also use the date interval add operation as "date + INTERVAL 1 DAY". The tutorial exercise below gives you some good examples:
SELECT DATE_ADD(DATE('1997-01-31'), INTERVAL 1 DAY) FROM DUAL; 1997-02-01 SELECT DATE('1997-01-31') + INTERVAL 1 DAY FROM DUAL; 1997-02-01
⇒ Decrementing a Date by 1 in MySQL
⇐ Date and Time Intervals in MySQL
2017-12-26, 1615🔥, 0💬
Popular Posts:
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...