Floor function in Microsoft SQL 2008
Posted on 2014-01-08
I want to use the floor function my SQL syntax
for an example
I wanted to change the value from 95.222 to 95.125 using the Floor function. I can do it using the Excel Floor function, but I want to do the same thing in Microsoft SQL Server too.
I tried using the similar syntax but get an error message "The floor function requires 1 argument(s)
using this syntax
select (Floor(ProductCost, 0.125)) from Product
and the syntax is okay if I change to
Select (Floor(ProductCost)) from Product
anyone ever work on that before??