If Mack wants to display the number of days between two dates, such as the current date and an invoice date from a table, which function can he use in his MySQL query to accomplish this?
A) DATE_ADD()
B) SUBTRACT()
C) DATEDIFF()
D) SYSDATE()

Question

Quizplus · Accepted Answer

DATEDIFF() is the correct function to use when wanting to calculate the number of days between two dates in MySQL. It returns the difference in days between two date values.

If Mack Wants to Display the Number of Days Between