Eine Einführung in

SQL

Subtract dates

MySQL
SQL Standard allows dates to be subtracted. We specify the unit and the number of digits of the result answer: YEAR MONTH DAY HOUR MINUTE SECOND

We want to know how long has it been since Tom Jones featured on TOTP.



Specific to MySQL
We may use the TO_DAYS function which tells use how many days since year 0.
See 6.3.4 Date and Time Functions for more details.