Trim from right side after decimal

Question

Hi We have value 146064.000000 . We want to remove 3 decimals from right side after decimal. Value should be 146064.000 Thanks

Jignesh Kumar · Answer

Hello ramco You can do it in multiple ways please find below examples declare @YourCoulmName decimal = 146064.000000 SELECT CONVERT(DECIMAL(183)@YourCoulmName) AS ConvertedValue SELECT FORMAT(@YourCoulmName 'N3') AS ConvertedValue; SELECT CAST(@YourCoulmName AS DECIMAL(183)) AS ConvertedValue;

Naimish Makwana · Answer

You can use the ROUND function in SQL to round a number to a certain number of decimal places. Here is how you can do it: SELECT ROUND(your_column 3) as rounded_value FROM your_table; In the above SQL statement replace your_column with the name of the column that contains the value you want to round and your_table with the name of your table. This will round the values in the specified column to 3 decimal places. Thanks

Tuhin Paul · Answer

If you want to remove three decimal places from a given number in many programming languages you can achieve this by converting the number to a string and then formatting it according to your needs. Below are examples in several common programming languages: value = 146064.000000 formatted_value = {:.3f}.format(value).rstrip('0').rstrip('.') print(formatted_value) JavaScript: let value = 146064.000000; let formattedValue = value.toFixed(3).replace(/\.?0+$/ ''); console.log(formattedValue); C#: double value = 146064.000000; string formattedValue = value.ToString(F3).TrimEnd('0').TrimEnd('.'); Console.WriteLine(formattedValue); Choose the code snippet corresponding to the programming language you are using. These examples use string formatting to achieve the desired result by limiting the number of decimal places and then removing trailing zeros and the decimal point. Adjust the code as needed for your specific requirements and programming environment.