Menu
I have table which has a column of float data type in SQL Server I want to return my float datatype column value with 2 decimal places.
for ex: if i insert 12.3,it should return 12.30
if i insert 12,it should return 12.00
642
For bigint use SELECT substr((2.938 % 1)::text,3)::bigint; , else use text result.
A) Using TRUNCATE function with a positive number of decimal places. In this example, the TRUNCATE() function truncated a number down to two decimal places.
select cast(your_float_column as decimal(10,2)) from your_table decimal(10,2) means you can have a decimal number with a maximal total precision of 10 digits. 2 of them after the decimal point and 8 before.
The biggest possible number would be 99999999.99
161
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
