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, 1492🔥, 0💬
Popular Posts:
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...