MySQL formatting time with am / pm lowercase

Question

Is there a better way to format a time field to have lowercase letters AM or PM? This is what I have in the SELECT statement, but it works, but it is pretty awkward:

CONCAT_WS('', DATE_FORMAT(time, '%l:%i '), LOWER(DATE_FORMAT(`time`, '%p'))) AS time 

I think more importantly, is there any significant overhead associated with formatting using SQL functions like this?

Answer 1

you can do it without calculus.

 LOWER(DATE_FORMAT(`time`,'%l:%i %p')) 

SEE HERE @SQLFiddle