# MAKETIME () and MICROSECOND () in MariaDB

Last Updated : 10 Nov, 2020

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 :

Parameter Description
hour The hour value which will be used to create the time.
minute The minute value which will be used to create the time.
second The 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 –

Parameters Description
date_value A 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
```

Previous
Next