MySQL MAKETIME() Function
Example
Create and return a time value based on an hour, minute, and second value:
SELECT MAKETIME(11, 35,
4);
Try it Yourself »
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);
Try it Yourself »
Example
Create and return a time value based on an hour, minute, and second value:
SELECT MAKETIME(21,
59, 59);
Try it Yourself »
Example
Create and return a time value based on an hour, minute, and second value:
SELECT MAKETIME(838,
59, 59);
Try it Yourself »