SQLite has introduced the FORMAT() function, which can be used to format strings.
More precisely, it has actually just renamed its SQL PRINTF() function to FORMAT(). The reason is for better compatibility with other DBMSs. The original PRINTF() name is retained as an alias for backwards compatibility.
The FORMAT() function (or its naming) was introduced in SQLite 3.38.0, which was released on 22 February 2022.
SQLite 3.38.0 was released on 2nd February 2022. With it came some enhancement to the date and time functions.
One of those enhancements is the addition of the UNIXEPOCH() function. This function returns a unix timestamp. That is, the number of seconds since 1970-01-01 00:00:00 UTC.
Here are several ways to get a list of functions in Oracle Database.
Continue readingIn SQL Server, the NULLIF() expression checks the value of two specified expressions. It returns a null value if they’re equal, otherwise it returns the first expression.
Below are two options we can use to return a list of functions in MySQL.
Continue readingIn MySQL, the SCHEMA() function is a synonym for the DATABASE() function. It returns the default (current) database name.
The result is returned as a string in the utf8 character set. If there is no default database, it returns NULL.
In PostgreSQL, the SUM() function computes the sum of the non-null input values and returns the result.
In other words, it adds numbers and returns the result.
Continue readingIn PostgreSQL, the AVG() function computes the average (arithmetic mean) of all the non-null input values, and returns the result.
Here are three options for listing out all functions in a PostgreSQL database.
Continue readingIn SQL Server, the SUM() aggregate function returns the sum of a given expression.
It can also be used to return the sum of all distinct (unique) values in the expression.
SUM() only works on numeric columns. Null values are ignored.