THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL MAKETIME() Function

❮ MySQL Functions

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 »

❮ MySQL Functions