SQL Display two digits after decimal point
###### Posted by SceDev
Last Updated: February 08, 2024

The scripts below demonstrate how to display two digits after decimal point in SQL.

Using CAST:

`SELECT CAST(344.3423 as DECIMAL(10,2))`

Using CONVERT:

```SELECT CONVERT(DECIMAL(10, 2), 344.3423)
```
###### Java program that reads an integer and prints how many digits the number has
Samath | Feb 11, 2021
###### Decimal to Binary in C++
Samath | Dec 26, 2014
###### Python Convert Decimal to Binary or Binary to Decimal
Samath | Jan 09, 2017
###### C++ Summing the digits in an integer
Samath | Jan 06, 2021
###### Recursive function that find the sum of digits in a integer using C++
Samath | Dec 24, 2014
###### Summing the Digits in an Integer using Python
Samath | Mar 02, 2015
###### Convert Roman numerals to decimal using Java
Samath | Jan 17, 2024
###### Converting Time To Decimal using C++
Samath | Jan 04, 2017
###### C++ Convert from Decimal to Octal
Samath | Jan 05, 2017
###### Binary to Decimal Conversion in C#
Samath | Jan 10, 2021
###### C++ program that prompts the user to input a decimal number and outputs the number rounded to the nearest integer
Samath | Apr 06, 2022
###### C program that prompts the user for a positive integer and then computes the sum of all the digits of the number
Samath | May 04, 2016
###### Python to Convert Decimal to Binary, Octal and Hexadecimal
gideonna | Apr 13, 2016
###### C++ program that prompts the user to input five decimal numbers, prints the five decimal numbers, converts each decimal number to the nearest integer, adds the five integers and prints the sum and average of the five integers.
Samath | Apr 06, 2022