| 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. | ||