In MariaDB, BIT_LENGTH() is a built in string function that returns the length of the given string argument in bits.
You provide the string as an argument when you call the function.
string functions
How BIN() Works in MariaDB
In MariaDB, BIN() is a built in string function that returns a string representation of the binary value of the given longlong (i.e. BIGINT) number.
You provide the longlong number when you call the function.
How COLLATION() Works in MariaDB
In MariaDB, COLLATION() is a secondary built in function that returns the collation of a given string.
We provide the string when we call the function.
How CHAR() Works in MariaDB
In MariaDB, CHAR() is a built-in string function that returns characters based on their code values.
CHAR() accepts one or more integers. It then returns a string consisting of the characters given by the code values of those integers.
How CHR() Works in MariaDB
In MariaDB, CHR() is a built-in string function that returns a character based on the code values provided as an argument.
Get the Right Part of a String in SQL Server (T-SQL)
In SQL Server, you can use the RIGHT() function to extract the right part of a string.
It works exactly the same as the LEFT() function (which returns the left part of a string), except that it returns the right part of the string.
Get the Left Part of a String in SQL Server (T-SQL)
In SQL Server, you can use the LEFT() function to extract the left part of a string.
It works exactly the same as the RIGHT() function (which returns the right part of a string), except that it returns the left part of the string.
Examples of Formatting ‘datetimeoffset’ in SQL Server using Standard Format Strings (T-SQL)
I thought it would be interesting to run a few quick queries to see how various formatting strings affect the formatting of date/time values.