Below is a full list of the datetime format elements in Oracle Database.
Continue readingTag: reference
How to Return a List of Valid Time Zones in Oracle Database
Sometimes we need to specify a time zone when using datetime functions in Oracle.
But there are a lot of time zones out there. How do we remember them all? And how do we know our system supports a given time zone?
Fortunately, we can query the V$TIMEZONE_NAMES view to return a list of valid time zones.
Methods of Setting NLS Parameters and their Priorities (Oracle Database)
Oracle Database includes a bunch of NLS (National Language Support) parameters that determine the locale-specific behaviour on both the client and the server.
These NLS parameters can be set in various places, each of which has a predetermined precedence order in relation to the others. The following table outlines these methods, as well as their priority in relation to the others.
Continue readingNumeric Functions in Oracle (Full List)
Below is a list of numeric functions in Oracle Database.
Continue readingMariaDB Numeric Functions (Full List)
This article contains a full list of built-in MariaDB numeric functions and operators.
Continue readingMariaDB String Functions (Full List)
This article contains a full list of built-in MariaDB string functions and operators.
Continue readingMariaDB Date & Time Functions (Full List)
This article contains a full list of built-in MariaDB date and time functions.
Continue readingDate & Time Locales Available in MariaDB
Below is a full list of date and time locales available in MariaDB.
Continue readingMariaDB 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.
Continue reading