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.
reference
MySQL 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).
JSON Functions & Operators in SQLite (Full List)
Below is a full list of JSON functions and JSON operators available in SQLite.
Date & Time Units in MySQL (Full List)
Here’s a list of units that can be used in MySQL datetime and interval functions.
List of MySQL Date Format Specifiers
Here’s a list of MySQL format specifiers that can be used in format strings with functions like DATE_FORMAT(), STR_TO_DATE(), and UNIX_TIMESTAMP().
List of Territories Supported by Oracle Database
Below is a list of territories that are supported by Oracle Database. These can be used when setting the NLS_TERRITORY initialization parameter.