How to convert TIME from 24 HR to AM/PM format in mysql
select DATE_FORMAT(<coulmn_name>,'%l:%i %p') as time from table_name;