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, 1523🔥, 0💬
Popular Posts:
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...