In MariaDB, the NULLIF() function returns NULL if both of its arguments are equivalent. Otherwise it returns the first argument.
How to Convert a Unix Timestamp to a Date/Time Value in PostgreSQL
In PostgreSQL, we can use the to_timestamp() function to convert a Unix timestamp value to a date/time value.
The Unix timestamp (also known as Unix Epoch time, Unix time, or POSIX time) is the number of seconds that have elapsed since 00:00:00 Thursday, 1 January 1970, Coordinated Universal Time (UTC).
Continue reading4 Ways to Find Rows that Contain Uppercase Letters in MariaDB
Here are four options for returning rows that contain uppercase characters in MariaDB.
Continue reading2 Ways to Return Rows that Contain Non-Alphanumeric Characters in PostgreSQL
Below are two options for returning rows that only contain non-alphanumeric characters in PostgreSQL.
Non-alphanumeric characters include punctuation characters like !@#&()–[{}]:;',?/* and symbols like `~$^+=<>“, as well as whitespace characters like the space or tab characters.
MySQL IFNULL() Explained
MySQL has an IFNULL() function that allows us to easily replace NULL values with another value.
Oracle ISNULL() Equivalent
Most major DBMSs provide us with a function for replacing null values with another value.
But the name of the function tends to differ across DBMSs. For example, SQL Server has an ISNULL() function, while others (such as MySQL, MariaDB, and SQLite) have an IFNULL() function for doing the same thing.
However, to confuse matters, MySQL and MariaDB each have an ISNULL() function that works differently to SQL Server’s function of the same name (MySQL and MariaDB’s implementation only accept a single argument, and return 1 if its null and 0 if it’s not).
MySQL ISNULL() Explained
In MySQL, the ISNULL() function enables us to check whether a value is null or not. If it’s null, then 1 is returned, otherwise 0 is returned.
2 Ways to Return Non-Numeric Values in SQLite
The following SQLite examples return only those rows that have non-numeric values in a given column.
Continue readingSubtract Weeks from a Date in PostgreSQL
We can use the - operator to subtract one or more weeks from a date in PostgreSQL.
How IFNULL() Works in MariaDB
In MariaDB, the IFNULL() function allows us to replace NULL values with another value.