Tag: mysql time format string

MySQL TIME_FORMAT Function

Example

Format a time:

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

Definition and Usage

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

Syntax

TIME_FORMAT(time, format)

Continue reading MySQL TIME_FORMAT Function