TIME_FORMAT

The TIME_FORMAT() function converts the input time object to a string according to the specified format.

TIME_FORMAT (timeobj, format)

Arguments

  • timeobj: A valid time, date, datetime, or parsable date string

  • format: A string containing format symbols. Only format symbols for the hour, minute, second, and microsecond parts are valid.

Refer to DATE_FORMAT for a description of format symbols.

Return Type

String

Examples

SELECT TIME_FORMAT('12:05:47', '%s, %i, %h');
+---------------------------------------+
| TIME_FORMAT('12:05:47', '%s, %i, %h') |
+---------------------------------------+
| 47, 05, 12                            |
+---------------------------------------+

Last modified:

Was this article helpful?