Example
Create and return a time value based on an hour, minute, and second value:
SELECT MAKETIME(11, 35, 4);
Definition and Usage
The MAKETIME() function creates and returns a time based on an hour, minute, and second value.
Syntax
MAKETIME(hour, minute, second)
Parameter Values
| Parameter | Description |
|---|---|
| hour | Required. The hour value |
| minute | Required. The minute value |
| second | Required. The seconds value |
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Create and return a time value based on an hour, minute, and second value:
SELECT MAKETIME(16, 1, 0);
Example
Create and return a time value based on an hour, minute, and second value:
SELECT MAKETIME(21, 59, 59);
Example
Create and return a time value based on an hour, minute, and second value:
SELECT MAKETIME(838, 59, 59);