[Solved] changing the time format from HH:MM:SS to HH:MM AM/PM [duplicate] August 21, 2022 by Kirat Try SELECT TIME_FORMAT('10:20:00', '%h:%i %p') Here is the SQLFiddel Demo 0 solved changing the time format from HH:MM:SS to HH:MM AM/PM [duplicate]