What Is Subdate in Sql?

What Is Subdate in Sql?

The SUBDATE() function subtracts a time/date interval from a date and then returns the date.

What is Subdate?

SUBDATE() function in MySQL is used to subtracts a time value (as interval) from a given date. ... expr : The value of the time/date interval to subtract. unit : The type of interval.

What is Date_sub in MySQL?

DATE_SUB() function in MySQL is used to subtract a specified time or date interval to a specified date and then returns the date. ... And here the addunit is the type of interval to subtract such as SECOND, MINUTE, HOUR, DAY, YEAR, MONTH etc.

Marcus Vance
Author

Marcus Vance

Marcus Vance is a cybersecurity auditor and technology writer dedicated to educating the public about online safety, data privacy regulations, enterprise security, and emerging cyber threats.