Collections:
Decrementing a Date by 1 in MySQL
How To Decrement Dates by 1 in MySQL?
✍: FYIcenter.com
If you have a date, and you want to decrement it by 1 day, you can use the DATE_SUB(date, INTERVAL 1 DAY) function. You can also use the date interval subtraction operation as "date - INTERVAL 1 DAY". The tutorial exercise below gives you some good examples:
SELECT DATE_SUB(DATE('1997-03-01'), INTERVAL 1 DAY) FROM DUAL; 1997-02-28 SELECT DATE('1997-01-31') - INTERVAL 1 DAY FROM DUAL; 1997-02-28
⇒ Calculating the Difference between Two Dates in MySQL
⇐ Incrementing a Date by 1 in MySQL
2017-12-26, 1596👍, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard ...