Mega Code Archive

 

Categories / MSSQL Tutorial / Math Functions

 

FLOOR returns the value that represents the largest integer that is less-than or equal to the input_number

The syntax  for the FLOOR  function is as follows: FLOOR(input_number) 9> SELECT 5-2*FLOOR(5/2) 10> GO -----------           1 (1 rows affected) 1>