number format – Page 2

How PARSE() Works in SQL Server

January 21, 2023 by Ian

In SQL Server, the PARSE() function returns the result of an expression, translated to the requested data type.

Basically, it enables us to parse a string expression to the specified data type. It’s intended for converting string values to either date/time or number types.

The PARSE() function can be handy when attempting to convert with CAST() or CONVERT() fails. The PARSE() function is able to parse the expression, and this may result in certain values being converted that wouldn’t normally be able to be converted.

3 Ways to Convert an Integer to Decimal in SQL Server

February 23, 2022 by Ian

Here are three options for converting an integer to a decimal value in SQL Server using T-SQL.

4 Functions to Format a Number to 2 Decimal Places in SQL Server

February 9, 2022 by Ian

When using T-SQL with SQL Server, we can format numbers using various methods, depending on our desired format.

Below are four functions that can be used to format a number to two decimal places in SQL Server.

How to Format Numbers as Roman Numerals in Oracle

February 3, 2022 by Ian

When using the TO_CHAR() function in Oracle Database, you can use the RN format element to return the number as roman numerals. Using lowercase (rn) returns the roman numerals in lowercase.

How to Format Numbers in Scientific Notation in Oracle

January 30, 2022 by Ian

When using the TO_CHAR() function in Oracle Database, you can use the EEEE format element to return the number in scientific notation.

Formatting Numbers with Commas in MariaDB

January 13, 2022 by Ian

In MariaDB, we can use the FORMAT() function to format a number with commas.

More specifically, the function returns the number as a formatted string, with thousands separators and a decimal separator, and rounded to the given decimal position.

Find Out Which Currency Symbol your Session Uses in Oracle

January 8, 2022 by Ian

In Oracle Database, the following NLS parameters can be used to determine how currencies are displayed for the current session:

NLS_CURRENCY specifies the string to use as the local currency symbol for the L number format element.
NLS_ISO_CURRENCY determines what to use for the C format element.
NLS_DUAL_CURRENCY specifies what to use for the U format element.

The default value for these is determined by the NLS_TERRITORY parameter.

The L, C, and U number format elements can be used in functions like TO_CHAR() to format a number as a currency.

How to Remove the Zero when the Integer Part is Zero in Oracle

December 31, 2021 by Ian

When using the TO_CHAR() function to format a number in Oracle Database, you can use the B format element to return blanks for the integer part of a fixed-point number when the integer part is zero.

This works regardless of zeros in the format model.

Format a Phone Number in SQL Server (T-SQL)

December 21, 2021 by Ian

Here are some examples of formatting phone numbers in SQL Server.

This includes examples of formatting numbers in E.164 format (for international numbers), prepending the country code and area code, as well as omitting leading zero from the country code when required.

How to Format Numbers with Commas in SQL

March 11, 2022December 13, 2021 by Ian

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.