MySQL MAKETIME()

MySQL 날짜함수, 시간함수

 

MAKETIME()

   - 주어진 값으로 시간(time)을 return?

 

MAKETIME(hour, minute, second)

의 형태

 

Returns a time value calculated from the hour, minute, and second arguments.

The second argument can have a fractional part.

 

 

mysql> SELECT MAKETIME(12, 15, 30);
+----------------------+
| MAKETIME(12, 15, 30) |
+----------------------+
| 12:15:30             |
+----------------------+
1 row in set (0.00 sec)

 

 

mysql> SELECT MAKETIME(12, 15);
ERROR 1582 (42000): Incorrect parameter count in the call to native function 'MAKETIME'