Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

get two decimal places in sql server

select cast(10.3333 AS DECIMAL(10,2)) Result -- 10.33
select cast(10 AS DECIMAL(10,2)) Result -- 10.33

select cast(your_float_column as decimal(10,2))
from your_table
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #decimal #places #sql #server
ADD COMMENT
Topic
Name
5+1 =