怎么对123.45取整？

[ItOldHorse]

怎么对123.45取整？

[qinqindodo]

floor(123.45)

[tangxc2003]

1： select convert(int,str(round(1234.566-0.5,0))) ---不四舍五入 //1234
2： select convert(int,str(round(1234.566,0))) ---四舍五入 //1235
3： select floor(1234.566) ---不四舍五入 //1234
4： select ceiling(1234.566) --- //1235
5： select convert(int,1234.566) //1234
6： select cast(1234.566 as int) //1234

[dlpseeyou]

select str(123.45)

[windstar]

convert(int,123.45)

[lansquenet]

cast(123.45 as int)

[wzh1215]

select cast(round(213.55,0) as int)

[lvltt]

cast(round(123.45,0) as int)

[pengdali]

select cast(123.45 as int)

[pengdali]

四舌五入:

select cast(round(123.45,0) as int)

[devilwind]

SELECT FLOOR(123.45),

[welyngj]

select ceiling(1234.566) --四舌五入