Here are three options for returning the first day of a month in MariaDB.
This could be the first day of the current month, or the first day of the month based on a date that we specify.
how to
Return Only Numeric Values in SQL
If you ever need to use SQL to return just the numeric values in a character column, the method you use will largely depend on your DBMS. Most DBMSs support regular expressions (regex), but some don’t. And some include functions that can detect numeric values.
Here are examples of how to do it in the more popular DBMSs.
3 Ways to Get the Definition of a Generated Column in SQLite
When we have a table with a generated column, here are two methods we can use to return its definition.
How to Create a Generated Column in Oracle
Oracle Database supports the creation of generated columns. A generated column is a column whose value is derived from an expression that computes values from other columns.
In Oracle Database, generated columns are usually referred to as virtual columns. Generated columns can also be referred to as computed columns in other RDBMSs (such as SQL Server). Either way, they do pretty much the same thing – they contain an expression that computes a value based on values in other columns in the same table.
How to Get the First Day of the Month in Oracle
Here’s an example of returning the first day of a given month in Oracle Database. We can return the first day of the current month, a previous or later month, or the first day of a month based on a specified date.
2 Ways to Check your Redis Client Version
Here are two quick and easy options to find out what version of the Redis client (redis-cli) you’re using.
4 Ways to Check your Redis Version
Here are four quick and easy ways to find out what version of Redis you’re using.
Install Redis on a Mac with Homebrew
Below are the steps that I used to install Redis on my M1 Mac. The M1 Mac (and M2) uses the ARM64 architecture, but this is not a problem, as Redis versions 4.0 and above support the ARM architecture.