In SQL Server, you can use the LOGINPROPERTY() to return information about login policy settings.
This includes being able to return data for bad password attempts, as well as the time of the last failed login attempt due to a bad password.
DBMS
Database Management Systems
Format Numbers with Commas in PostgreSQL
In PostgreSQL, we can use the TO_CHAR() function to format numbers in a given format. This includes formatting numbers with commas in the relevant location.
PostgreSQL also has a money data type, which outputs the value using the current locale. This can include commas in the appropriate place, based on the locale being used.
How to Get the Day, Month, and Year from a Date in SQL
Most of the major RDBMSs have functions that enable us to extract the day, month, and year from datetime values.
Some RDBMSs provide multiple ways to do this, and others are more limited. Below are examples of extracting the day, month, and year from date values in some of the most popular RDBMSs.
FORMAT() Examples in MySQL
In MySQL, the FORMAT() function returns a number formatted to a specified number of decimal places.
It includes group separators and a decimal separator where applicable.
How to Format Numbers with Commas in SQL Server
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.
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.
Date & Time Units in MySQL (Full List)
Here’s a list of units that can be used in MySQL datetime and interval functions.