Skip to content
Related Articles

Related Articles

MAKETIME () and MICROSECOND () in MariaDB
  • Last Updated : 10 Nov, 2020
GeeksforGeeks - Summer Carnival Banner

MAKETIME Function :
In MariaDB, MAKETIME Function is used to returns the time for a certain hour, minute, the second combination. In this function, the first parameter will be an hour, the second parameter will be minute and third will be second. This function will return the combination of the hour, minute and second. Time values range from ‘-838:59:59’ to ‘838:59:59’.

Syntax :

MAKETIME( hour, minute, second )

Parameter :

ParameterDescription
hourThe hour value which will be used to create the time.
minuteThe minute value which will be used to create the time.
secondThe second value which will be used to create the time.

Return :
It will return the time for a certain hour, minute, the second combination.

Example –



SELECT MAKETIME(9, 49, 15);

Output :

'09:49:15'

Example –

SELECT MAKETIME(23, 59, 59);

Output :

'23:59:59'

Example –

SELECT MAKETIME(-838, 59, 59);

Output :

'-838:59:59'

MICROSECOND Function :
In MariaDB, The Microsecond Function is used to return the microsecond portion of a date value. In this function, the first parameter will be date_value. This function will return returns the microsecond portion of a date value. This function returns the microsecond portion (a number from 0 to 999999) given a date value.

Syntax :

MICROSECOND( date_value )

Parameters –



ParametersDescription
date_valueA time or datetime value from which to extract the microsecond.

Return :
microsecond

Example –

SELECT MICROSECOND('2017-01-29 03:22:05.000001');

Output :

1

Example –

SELECT MICROSECOND('2017-07-15');

Output :

0

Example –

SELECT MICROSECOND('10:16:06.294675');

Output :

294675

Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up
Recommended Articles
Page :