Mega Code Archive

 

Categories / MySQL / Date Time

 

SELECT TIME_FORMAT(02

mysql> mysql> SELECT TIME_FORMAT('02:17', '%H'); +----------------------------+ | TIME_FORMAT('02:17', '%H') | +----------------------------+ | 02                         | +----------------------------+ 1 row in set (0.00 sec)