In SQL Server, an often used function is CAST(), which converts an expression of one data type to another. But if the cast doesn’t succeed, then it returns an error.
Enter TRY_CAST().
The TRY_CAST() function doesn’t return an error if the cast fails. Instead, it returns NULL.
There are some occasions however, where it will return an error.
In SQLite, there are quite a few ways to look at a table’s structure. Therefore, there are quite a few ways we can check the data type of the columns within that table.
There’s also a function that allows us to check the data type of a column returned in a query.
Here are five ways to check the data type of a column in SQLite.
Here are some options for subtracting one or more seconds from a datetime expression in MariaDB.
Here are three ways to get the data type of a given column in MariaDB.
In MariaDB, we can use the SHOW PROCEDURE STATUS command to return a list of stored procedures.
We can also query the information_schema.routines table to do the same thing.
Here are three ways to get information about a table’s columns in Oracle, including their data types.
Here are four ways to get the data type of a column in MySQL.
Here’s a quick way to return random rows from a table in MariaDB.
Most of the major RDBMSs have functions that enable us to format numbers with commas as either the group separator, or the decimal separator.
Some RDBMSs also output certain numeric data types with commas in the relevant place.
Below are examples of formatting numbers with commas in some of the more popular DBMSs.