In PostgreSQL, LPAD()is a function that enables us to add padding to the left part of a string.
what is
FORMAT() Examples in MySQL
In MySQL, the FORMAT() function returns a number formatted to a specified number of decimal places.
It includes group separators and a decimal separator where applicable.
How CONCAT_WS() Works in PostgreSQL
In PostgreSQL, the CONCAT_WS() function concatenates two or more strings, placing a separator between each one. The separator is specified by the first argument.
How the CONCAT() Function Works in PostgreSQL
In PostgreSQL, the CONCAT() function concatenates the text representations of its arguments.
About the DATE_BUCKET() Function in Azure SQL Edge
T-SQL includes a DATE_BUCKET() function that allows you to arrange data into groups that represent fixed intervals of time. It returns the datetime value that corresponds to the start of each datetime bucket, as defined by the arguments passed to the function.
As far as I’m aware, the DATE_BUCKET() function is only available in Azure SQL Edge at the time of this writing.
Update: DATE_BUCKET() was introduced in SQL Server 2022.
JSON_OBJECTAGG() Function in Oracle
In Oracle Database, the JSON_OBJECTAGG() function creates a JSON object from a key-value pair.
Typically, the property key, the property value, or both are columns of SQL expressions.
JSON_OBJECT() Function in Oracle
In Oracle Database, the JSON_OBJECT() function creates a JSON object from a sequence of key-value pairs or one object type instance.
JSON_ARRAYAGG() Function in Oracle
In Oracle Database, the JSON_ARRAYAGG() function creates a JSON array from a column of SQL expressions.