This article contains a full list of built-in MariaDB date and time functions.
reference
Date & Time Locales Available in MariaDB
Below is a full list of date and time locales available in MariaDB.
MariaDB Date Format Strings
Below is 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 MariaDB.
MariaDB Date and Time Units
Below is a full list of the date and time units that can be used in MariaDB.
MongoDB Whitespace Characters
The following table contains a list of whitespace characters that MongoDB removes by default when using the $trim, $ltrim, and $rtrim aggregation pipeline operators.
List of Date Formats Available with CONVERT() in SQL Server
The following table contains a list of the date formats that you can provide to the CONVERT() function when you convert a date/time value to a string.
These formats are provided as an optional third argument when calling the CONVERT() function. They’re provided as an integer expression that specifies how the CONVERT() function will format the date.
12 Commonly Used SQL Operators
In SQL, an operator is a special character or keyword specifying an action that is performed on one or more expressions.
SQL operators are an integral part of SQL, and they enable us to write queries that return relevant results.
In this article, I present 12 of the most commonly used SQL operators when writing SQL queries.
Valid Time String Formats for SQLite Date/Time Functions
Below is a list of valid time string formats that you can use in any date and time function in SQLite.
