MySQL TIME_FORMAT() Function

SELECT TIME_FORMAT("19:30:10", "%H %i %s");

The TIME_FORMAT() function formats a time by a specified format.

TIME_FORMAT( time, format )

Required. The time to be formatted format Required. The format to use. Can be one or a combination of the following:

%f Microseconds (000000 to 999999) %H Hour (00 to 23) %h Hour (00 to 12) %I Hour (00 to 12) %i Minutes (00 to 59) %p

%r

%S Seconds (00 to 59) %s Seconds (00 to 59) %T Time in 24 hour format (hh:mm:ss)

From MySQL 4.0

SELECT TIME_FORMAT("19:30:10", "%h %i %s %p");

SELECT TIME_FORMAT("19:30:10", "%r");

SELECT TIME_FORMAT("19:30:10", "%T");

❮ MySQL Functions