Displaying date/time

[Tompkins Neil]

Hi

I have a number of rows which have Date and Time data in.  I want to display
in the following formats based on the systems current time

e.g under 1 hour 24min ago
e.g under 1 day 16h 29min ago
e.g over 1 day 1d 2h 29min ago
e.g over 1 week 1w 4d 2h 29min ago

How would this best be achieve using MySQL.

Thanks,
Neil