In PostgreSQL, we can use the STRING_AGG() function to return columns from a query as a delimited list.
How POSITION() Works in PostgreSQL
PostgreSQL has a POSITION() function that returns the first starting index of a specified substring within a string.
If the substring doesn’t exist in the string, then zero is returned.
How to Format Numbers with Leading Zeros in SQLite
In SQLite, we can use the PRINTF() function or FORMAT() function to format numbers with leading zeros.
How to Add Leading & Trailing Zeros in Azure SQL Edge
Azure SQL Edge uses a limited version of the SQL Server Database Engine. One of the limitations of Azure SQL Edge, is that it doesn’t currently support CLR-dependent T-SQL functions, such as the FORMAT() function.
This can be a problem when trying to format numbers.
However, there are often ways around such limitations. Here are examples of how we can pad numbers with leading and trailing zeros in SQL Edge.
How to Remove “X Rows Selected” in SQLcl & SQL*Plus (Oracle)
When using SQLcl or SQL*Plus with Oracle Database, you may have noticed feedback at the bottom of your query results that tells you how many rows were selected. For example, 100 rows selected (or however many rows were returned).
If you want to get rid of this, you can use SET FEEDBACK OFF.
You also have the option of setting a row threshold, which allows you to specify how many rows should be returned before feedback is provided.
8 Ways to Add an Hour to a Datetime in MariaDB
There are many ways to perform date arithmetic in MariaDB. This includes adding or subtracting a certain number of a given date part from a date or datetime value.
In this article, I present 8 ways to add an hour to a datetime value in MariaDB.