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.
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 readingBelow is a list of numeric functions in Oracle Database.
Continue readingThis article contains a full list of built-in MariaDB numeric functions and operators.
Continue readingThis article contains a full list of built-in MariaDB string functions and operators.
Continue readingThis article contains a full list of built-in MariaDB date and time functions.
Continue readingBelow is a full list of date and time locales available in MariaDB.
Continue readingBelow 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.
Below is a full list of the date and time units that can be used in MariaDB.
Continue readingThe following table contains a list of whitespace characters that MongoDB removes by default when using the $trim, $ltrim, and $rtrim aggregation pipeline operators.