Login

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);

Login
ADS CODE