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 DB2|
|The DAYS function gives us the number of days since a long time ago. The string "yymmdd" includes the number of years, months and days since.|