SELECT FLOOR(value)

http://msdn.microsoft.com/en-us/library/ms178531.aspx

FLOOR 返回小于或等于指定数值表达式的最大整数.

FLOOR returns the largest integer less than or equal to the specified numeric expression.