Below is an alphabetical list of functions that we can use when working with arrays in PostgreSQL.
Continue readingTag: reference
List of MySQL Window Functions
Below is a list of functions that can be used as window functions in MySQL.
Some are nonaggregate functions that can only be used as window functions, while others are aggregate functions that can be used as window functions if required.
Continue readingMySQL Aggregate Functions (Full List)
The following table contains a full list of the aggregate functions in MySQL.
Continue readingMySQL JSON Functions & Operators
Below is a list of the JSON functions and operators available in MySQL.
Continue readingMySQL Date & Time Functions (Full List)
The following is a list of date and time functions available in MySQL. Click on each function name to see an explanation of the function, its syntax, and examples.
Continue readingMySQL Date Format Specifiers (Full List)
The following table contains a full list of format specifiers that can be used in format strings with functions like DATE_FORMAT()
, STR_TO_DATE()
, and FROM_UNIXTIME()
in MySQL.
Binary Styles Supported by CONVERT() in SQL Server
Below is a list of binary styles supported by the CONVERT()
function in SQL Server. These are the styles that can be used as the third argument to indicate how the input value is formatted when converting to binary.
We can use these styles when the input expression is binary(n), char(n), varbinary(n), or varchar(n).
Continue readingXML Styles Supported by CONVERT() in SQL Server
Below is a list of XML styles supported by the CONVERT()
function in SQL Server. These are the styles that can be used as the third argument to indicate how the input value is formatted when converting to XML.
Date & Time Styles Supported by CONVERT() in SQL Server
Below is a list of date & time styles supported by the CONVERT()
function in SQL Server. These are the styles that can be used as the third argument to indicate how the input value is formatted.
Numeric Styles Supported by CONVERT() in SQL Server
Below is a list of numeric styles supported by the CONVERT()
function in SQL Server. These are the styles that can be used as the third argument to indicate how the input value is formatted.