sql server - ROUND() givin incorrect result in sql -
select round(849299099755.3,2) dual;
gives
849299099755.3 how can 849299099755.30 here???
convert datatype onto decimal
select convert(decimal(15,2), round(849299099755.3,2)) or
select str(round(849299099755.3,2), 20, 2) sql-server oracle tsql rounding
No comments:
Post a Comment