MySQL第二次格式化日期时间

Question

How to convert second to formatted date time in mysql? I have a query to get date difference in second. i.e

 SELECT TIMESTAMPDIFF(SECOND, '2012-06-03 13:13:55', '2012-06-06 15:20:18') sec

Now I need to convert this seconds in date time in SQL. Is it possible? Or Is there are any function in mysql to get DATETIME fields difference with formatted option like

SELECT DATEDIFF('%m %D, %Y %H...', '2012-06-03 13:13:55', '2012-06-06 15:20:18') sec

So my expected result is 1 mon 5 day 13 hour 3 sec

Answer 1

Check out this function date_format(date, format) date_format spec