MariaDB includes many functions that allow you to return time and datetime values in a variety of formats.
Two functions allow you to format the time portion using a 12 hour clock, with the AM/PM designator are DATE_FORMAT()
and TIME_FORMAT()
.
There are many format specifiers that can be used with these functions, but only a couple that return the AM/PM designator.
Continue reading