MySQL MAKETIME() Function
Example
Return the time for a certain hour, minute, second combination:
SELECT MAKETIME(11, 35,
4);
Try it Yourself »
Definition and Usage
The MAKETIME() function returns the time for a certain hour, minute, second combination.
Note: The time values range from "-838:59:59" to "838:59:59".
Syntax
MAKETIME(hour, minute,
second)Parameter Values
| Parameter | Description |
|---|---|
| hour | Required. The hour value used to create the time |
| minute | Required. The minute value used to create the time |
| second | Required. The second value used to create the time |
Technical Details
| Works in: | MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1.1 |
|---|
More Examples
Example
Return the time for a certain hour, minute, second combination:
SELECT MAKETIME(16,
1, 0);
Try it Yourself »
Example
Return the time for a certain hour, minute, second combination:
SELECT MAKETIME(21,
59, 59);
Try it Yourself »
Example
Return the time for a certain hour, minute, second combination:
SELECT MAKETIME(838,
59, 59);
Try it Yourself »
