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, 1505🔥, 0💬
Popular Posts:
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...