php Courses

Apr 3, 2023 · Databases

MySQL Date and Time Functions: addtime, adddate, date_add, subtime, subdate, date_sub

This article explains MySQL's date and time manipulation functions—including addtime, adddate, date_add, subtime, subdate, and date_sub—showing their syntax, usage with numeric and INTERVAL arguments, and providing example queries for adding or subtracting seconds, minutes, days, weeks, months, and years.