Floor()

[crabback]

I have a s2k Database that I have just inherited. In one of my views I have an aliased field that uses the calculation convert(varchar, Floor(cl_call_Logging.Time_solving / 60))... can anyone tell me what the Floor() function is? I thought it might be a user defined function but its not listed.

thanks

Crabback

 

[earthandfire]

Have you had a look for Floor in BOL (help) - it is there!!

 

[SQLDenis]

Floor is the oposite of ceiling
floor rounds down celing rounds up

run this

select ceiling(1.5), floor(1.5)


Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions