SQL TRUNCATE Vs ROUND Function
In this session, we'll go over what is
ROUND functions , as well as the differences between them.
SQL TRUNCATE Function
The TRUNC function cuts it off at the specified digits.
It's used to truncate a number to the amount of decimal places you choose.
TRUNCATE() does not round a number.
it just removes the decimal places that the user does not require.
Example 1: Consider the following example to truncate the given number
Select TRUNCATE(7.65342,3) As 'Get 3 number after decimal';
TRUNCATE() just removes the last decimal places, leaving only the first two decimal places, and returns 7.65 as 3the result.
Output: The output of truncate function is
|Get 3 number after deciaml|
If specified, the SQL ROUND() function is used to round an integer to a specified number of decimal places.
Assume that the salary value in the employee table for
ename='Exforsys' is 55.666.
The ROUND() method returns a value
X that has been rounded to the nearest integer.
D is specified as a second argument, the function returns
X rounded to
D decimal places.
All digits to the right of the decimal point will be eliminated if
D is negative.
Example: Let's round the following query to the nearest tenth:324.456. Using the query below, we may do so.
The number 324.456 is round after 2 decimal places
SELECT ROUND(324.456, 2) AS RoundValue;
Output: The Output of above query is
SQL Differnce Between TRUNCATE And ROUND FUNCTION
Main distinguish in truncate vs round function points are tabulated . :-
|TRUNC() is a function that truncates or deletes a number from a specific location.||The ROUND() function is used to round an integer to the nearest decimal place.|
|TRUNC() returns an integer with a specified number of decimal places truncated. As a result, it always chooses the lower value.||The ROUND() function rounds a numeric field to the supplied number of decimals.|
|Truncate , which rounds up or down towards zero.||ROUND() in the direction of negative infinity.|