THE WORLD'S LARGEST WEB DEVELOPER SITE
HTML CSS JAVASCRIPT SQL PHP BOOTSTRAP HOW TO JQUERY W3.CSS ANGULARJS XML MORE FORUM EXAMPLES REFERENCES

MySQL TIME_FORMAT() Function

❮ MySQL Functions

Example

Format a time:

SELECT TIME_FORMAT("19:30:10", "%H %i %s");
Try it Yourself »

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 »

Example

Format a time:

SELECT TIME_FORMAT("19:30:10", "%r");
Try it Yourself »

Example

Format a time:

SELECT TIME_FORMAT("19:30:10", "%T");
Try it Yourself »

❮ MySQL Functions