In MariaDB, WEEK() is a built-in date and time function that returns the week from a given date expression.
It accepts two arguments; the date you want to extract the week from, and an optional mode argument to specify the mode to use in the result.
It returns the week as a number in the range 0 to 53 or 1 to 53, depending on the mode being used.
In MariaDB, MONTH() is a built-in date and time function that returns the month from a given date expression.
It accepts one argument, which is the date you want to extract the month from.
It returns the month as a number in the range 1 to 12 for January through December. If the date has a zero month part (e.g. 0000-00-00 or 2025-00-00), the result is 0.
In MariaDB, MICROSECOND() is a built-in date and time function that returns the microseconds portion of a given time expression.
It accepts one argument, which is the time you want to extract the microseconds from.
The seconds are returned as a number in the range 0 to 999999.
In MariaDB, SECOND() is a built-in date and time function that returns the seconds portion of a given time expression.
It accepts one argument, which is the time you want to extract the seconds from.
The seconds are returned as a number in the range 0 to 59.
In MariaDB, MINUTE() is a built-in date and time function that returns the minutes portion of a given time expression.
It accepts one argument, which is the time you want to extract the minutes from.
The minutes are returned as a number in the range 0 to 59.
In MariaDB, HOUR() is a built-in date and time function that returns the hour from a given time expression.
It accepts one argument, which is the time you want to extract the hour from.
For time-of-day values, it returns the hour as a number in the range 0 to 23. However, the range of TIME values can be much larger, and therefore, the returned value can be much higher than 23.
The return value is always positive, even if a negative time is provided.
Continue readingIn MariaDB, EXTRACT() is a built-in date and time function that returns the specified unit from a given date or datetime expression.
In MariaDB, DAYOFYEAR() is a built-in date and time function that returns the day of the year from a given date.
It accepts one argument, which is the date you want to extract the day of the year from.
It returns the day as a number in the range 1 to 366.
In MariaDB, WEEKDAY() is a built-in date and time function that returns the week day from a given date.
It accepts one argument, which is the date you want to extract the week day from.
It returns the day as a number. The index numbering starts at zero for Monday (i.e. 0 = Monday, 1 = Tuesday, etc). This is in contrast to DAYOFWEEK(), which adheres to the ODBC standard (1 = Sunday, 2 = Monday, etc).
In MariaDB, DAYOFWEEK() is a built-in date and time function that returns the day of the week from a given date.
It accepts one argument, which is the date you want to extract the day of the week from.
It returns the day as a number. The index numbering adheres to the ODBC standard (1 = Sunday, 2 = Monday, etc). This is in contrast to WEEKDAY(), where 0 = Monday, 1 = Tuesday, etc.