MySQL MAKETIME() Function
THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL MAKETIME() Function

❮ MySQL Functions

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 »

❮ MySQL Functions