Database Management Systems
In MariaDB, YEARWEEK() is a built-in date and time function that returns the year and week for a given date.
It accepts two arguments; the date you want to extract the year and 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. Also, the year in the result may be different from the year in the date argument for the first and the last week of the year.
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).