SQL Server provides us with a quick and easy way to format numbers with commas inserted at the relevant place. For example, 1234.56 can become 1,234.56. Or it can become 1.234,56, if that’s the locale that you’re using.
how to
2 Ways to Concatenate Strings and Numbers in MariaDB
Here are two ways to concatenate strings and numbers in MariaDB:
- Use the
CONCAT()function, which concatenates its arguments. - Use the pipe concatenation operator (
||), which concatenates its operands.
Below are examples of each.
Format Numbers with a Comma in SQLite
SQLite has a printf() function or format() function that allows us to format numbers according to a format string.
As from SQLite 3.18.0, it accepts a comma flag, which enables us to have comma separators at the thousands marks for integers.
Further work can be done to get it working with real/floating point numbers.
Concatenate a String and a Number in MySQL
There are a couple of approaches we can use to concatenate strings and numbers in MySQL.
- We can use the
CONCAT()function, which concatenates its arguments. - We can use the pipe concatenation operator (
||), which concatenates its operands.
Below are examples of each.
2 Functions that Get the Day, Month, and Year from a Date in Oracle
Oracle Database has the TO_CHAR(datetime) function that enables us to get various date parts from a datetime value.
There’s also the EXTRACT(datetime) function that extracts a specific datetime unit (e.g. day, month, year, etc).
2 Ways to Format your Query Results in SQLcl (Oracle)
When using SQLcl to run queries against Oracle Database, you can specify the output of the query results using the following two options:
- The
SET SQLFORMATcommand - Add a comment shortcut to your query
7 Options for Enabling Pipes (||) as the Concatenation Operator in MariaDB
By default, two pipe characters (||) are treated as a logical OR operator in MariaDB. However, you can change this behaviour if you like.
You can update your sql_mode to include the PIPES_AS_CONCAT option, in which case two pipes will be treated as a concatenation operator.
There are quite a few ways to add this option to your sql_mode. You can add it explicitly. Or you can set your sql_mode to an option that sets it implicitly.
I run through these options below.
How to Extract the Day, Month, and Year from a Date in SQLite
In SQLite, we can use the strftime() function to return datetime values in our chosen format.
Therefore, we can use it to extract the day, month, and year from a date.