Re: Calculating TIME ELAPSED SINCE in days OR hours OR minutes

[Dan LeGate]

Yup, got it working by removing Aliases (sure would be nice to be able to use them to make this code more compact):

SELECT TIMESTAMPDIFF(MINUTE, date_updated, now()) as MinutesElapsed,
CASE
WHEN TIMESTAMPDIFF(MINUTE, date_updated, now()) < 60 THEN concat(FORMAT(TIMESTAMPDIFF(MINUTE, date_updated, now()), 1), " minutes")
WHEN TIMESTAMPDIFF(MINUTE, date_updated, now()) > 60 and TIMESTAMPDIFF(MINUTE, date_updated, now()) < 1440 THEN concat(FORMAT(TIMESTAMPDIFF(MINUTE, date_updated, now())/60, 1), " hours")
WHEN TIMESTAMPDIFF(MINUTE, date_updated, now()) > 1440 THEN concat(FORMAT(TIMESTAMPDIFF(MINUTE, date_updated, now())/1440, 1), " days") END as "The Display"from time_elapsed

Thanks for all your help, both of you!