bugl
bugl
HomeLearnPatternsSearch
HomeLearnPatternsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MySQL MAKETIME() Function

Concept visual

MySQL MAKETIME() Function

Pointer walk
two pointers
leftright102132436485116
left=0
right=6
1
3

Start at both ends

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

Previous

❮ MySQL Functions

Next

Previous

MySQL MAKEDATE() Function

Next

MySQL MICROSECOND() Function