Below is a full list of datetime functions available in Oracle Database.
Continue readingTag: reference
Supported Format Models for the ROUND() and TRUNC() Date Functions in Oracle
Below is a full list of the format models that are available to be used with the ROUND(date) and TRUNC(date) functions in Oracle Database.
List of Datetime Format Elements in Oracle
Below is a full list of the datetime format elements in Oracle Database.
Continue readingHow 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 reading