MySQL Articles

How to Add and Subtract Dates from DateTime in MySQL

Tutorialsrack 24/05/2020 SQL MySQL

In this article, you will learn how to add or subtract years, months, weeks, days, hours, minutes, seconds, microseconds to a DateTime in MySQL. DateTime manipulation is the most common scenario is when we fetching data from the database or storing data in a database. Here, we used the MySQL built-in DateTime functions: ADDDATE(), DATE_ADD(), DATE_SUB(), and add and subtract dates without using any built-in function. 

Read More..
Recent Posts