MySQL TIME_FORMAT() Function
❮ MySQL Functions
Definition and Usage
The TIME_FORMAT() function formats a time as specified by a format mask.
Syntax
TIME_FORMAT(time, format_mask)
Parameter Values
| Parameter |
Description |
| time |
Required. The time to format |
| format_mask |
Required. The format to apply to time. Can be one or a
combination of the following
values:
| Format |
Description |
| %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 |
AM or PM |
| %r |
Time in 12 hour AM or PM format (hh:mm:ss AM/PM) |
| %S |
Seconds (00 to 59) |
| %s |
Seconds (00 to 59) |
| %T |
Time in 24 hour format (hh:mm:ss) |
|
Technical Details
| Works in: |
MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL
4.0, MySQL 3.23 |
More Examples
Example
Format a time:
SELECT TIME_FORMAT("19:30:10", "%h %i %s %p");
Try it Yourself »
❮ MySQL Functions
