SQL Server 2012

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE TEST_VAL(
   VAL float
)
insert into test_val values (16704.405);
1 rows affected

insert into test_val values (2683.135);
1 rows affected

insert into test_val values (20382.135);
1 rows affected

Select CAST(VAL as decimal(15,2)) AS NEWVAL 
from TEST_VAL;

NEWVAL

16704.40

2683.14

20382.13

select CONVERT(DECIMAL(15,2), ROUND(VAL, 2, 1)) AS NEWVAL from TEST_VAL;

NEWVAL

16704.40

2683.13

20382.13