MINUTE () and MONTH () in MariaDB
1. MINUTE () Function :
In MariaDB, Minute Function has used to return the minute portion of a date value. In this function, the first parameter will be the date. MINUTE Function will return the minute in which range will be from 0 to 59 and given a date value. We will pass a date/DateTime and it will return the minute part of that.
Syntax :
MINUTE( date_value )
Minute range = [ 0 to 59 ]
Parameter :
Parameter | Description |
---|---|
Date_value | A time or DateTime value from which to extract the minute. |
Return :
The minute portion of a date value.
Example-1 :
SELECT MINUTE('2019-05-19 09:21:18.000004');
Output :
19
Example-2 :
SELECT MINUTE('838:59:01');
Output :
59
Example-3 :
The curtime() function returns the current time. The current time is 07:27:24 rightnow.
SELECT MINUTE(CURTIME());
Output :
27
2. MONTH () Function :
In MariaDB, The Month Function is used to return the month portion of a date value. In this function, the first parameter will be date_value. In a date format it is one of the part of date and It will return the month values from 1 to 12 or Jan to Dec, etc. depends on different formats of date. This function returns the month (a number from 1 to 12) given a date value.
Syntax :
MONTH( date_value )
Month range (In number) = [1 to 12]
Parameters :
Parameters | Description |
---|---|
date_value | A time or DateTime value from which to extract the month. |
Return :
The month portion from date.
Example-1 :
SELECT MONTH('2017-06-19 09:04:10');
Output :
6
Example-2 :
SELECT MINUTE('838:59:01');
Output :
59
Example-3 :
The curtime() function returns the current time of the system. Today is 07-11-2020
SELECT MINUTE(CURTIME());
Output :
11
Contact Us