[Solved] changing the time format from HH:MM:SS to HH:MM AM/PM [duplicate]

[ad_1]

SELECT TIME_FORMAT('10:20:00', '%h:%i %p')

[ad_2]

solved changing the time format from HH:MM:SS to HH:MM AM/PM [duplicate]