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, 2024🔥, 0💬
Popular Posts:
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...