TIMESTAMPDIFF Format

[Alan Crookes]

I have the following query and am trying to work out how old the current table is based on the UPDATE_TIME field of the INFORMATION_SCHEMA Table.

I am using the following query:

SELECT INFORMATION_SCHEMA.TABLES.TABLE_NAME, TIMESTAMPDIFF(HOUR,INFORMATION_SCHEMA.TABLES.UPDATE_TIME,NOW()) FROM INFORMATION_SCHEMA.TABLES WHERE INFORMATION_SCHEMA.TABLES.TABLE_SCHEMA LIKE 'TABLE_NAME'

I have specified the TIMESTAMPDIFF at the moment as HOUR but I want it to be displayed in Minutes, then Hours, then Days as it gets older if you understand.
i.e. 59 mins old, 1 hour old, 3 hours old, 1 day 5 hours old and so on...

Any help would be appreciated.

Thanks,

Alan.