Left side of a floating point number in Sql Server

Question

I have a query returning a column of floating point numbers but I am only interested in the number before the decimal place. I don't want to round the number so I am looking for something like:

1.95 = 1
1.45678 = 1
12.00 = 12
12.9999 = 12

Is there an easy way to achieve this in SqlServer other than doing a substring?

Answer 1

You can use the floor function.

Answer 2

You can do this -

SELECT CAST(1.230 AS INT)

Output: 1

Answer 3

You could use ROUND(expression, 0, 1) to truncate a number in T-SQL. See MSDN for reference.