In MariaDB, TO_DAYS() is a built-in date and time function that returns the number of days from the start of the standard calendar (0000-00-00), based on a given date.
You pass the date to the function when you call it.
The TO_DAYS() function is the converse of the FROM_DAYS() function.
In MariaDB, FROM_DAYS() is a built-in date and time function that returns a date value based on a given number of days from the start of the standard calendar (0000-00-00).
You pass the number of days to the function when you call it.
The FROM_DAYS() function is the converse of the TO_DAYS() function.
Here are three ways to return the month name from a date in MariaDB.
Continue readingIn 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 readingMariaDB provides several ways to perform arithmetic on dates. This includes adding or subtracting a month (or many months) from a given date.
Here’s an example of subtracting a month from a date in MariaDB.
Continue readingIn 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.
There are (at least) a couple of ways you can use T-SQL to return the default language of a specified login in SQL Server.
In particular, you can use the following methods:
LOGINPROPERTY() function. sys.server_principals system catalog view in the master database.Examples of these are below.
Continue readingIn 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.
In SQL Server, you can use the sp_rename stored procedure to rename a user created object in the current database, including a user-defined data type.
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 reading