Mysql MAKETIME
From w3cyberlearnings
Contents |
MySQL MAKETIME Function
This function makes time calculated from hour, minute, and second input.
Syntax MAKETIME
MAKETIME(hour, minute, second);
Example 1
mysql> SELECT MAKETIME(3,50,30); +-------------------+ | MAKETIME(3,50,30) | +-------------------+ | 03:50:30 | +-------------------+ 1 row in set (0.00 sec)
Example 2
mysql> SELECT MAKETIME(133,50,30); +---------------------+ | MAKETIME(133,50,30) | +---------------------+ | 133:50:30 | +---------------------+ 1 row in set (0.00 sec)
