In MariaDB, LAST_DAY() is a built-in date and time function that returns the last day of the month for a given date.
It accepts one argument, which is the date for which you want to find the last day of the month.
Continue readingTag: date functions
How QUARTER() Works in MariaDB
In MariaDB, QUARTER() is a built-in date and time function that returns the quarter from a given date expression.
It accepts one argument, which is the date you want to extract the quarter from.
It returns the quarter as a number in the range 1 to 4. For dates with zero months (e.g. 0000-00-00 or 2025-00-00), the result is 0.
How YEAR() Works in MariaDB
In MariaDB, YEAR() is a built-in date and time function that returns the year from a given date expression.
It accepts one argument, which is the date you want to extract the year from.
It returns the year as a number in the range 1000 to 9999. For zero dates (e.g. 0000-00-00), the result is 0.
How WEEKOFYEAR() Works in MariaDB
In MariaDB, WEEKOFYEAR() is a built-in date and time function that returns the calendar week of a given date as a number in the range from 1 to 53.
It’s the equivalent of using the WEEK() function in mode 3, and therefore its result is in accordance with ISO 8601:1988.
It accepts one argument; the date you want to extract the week from.
Continue readingHow YEARWEEK() Works in MariaDB
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.
How WEEK() Works in MariaDB
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.
How MONTH() Works in MariaDB
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.
How MICROSECOND() Works in MariaDB
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.
How SECOND() Works in MariaDB
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.
How MINUTE() Works in MariaDB
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.