|
floor()
The
Mathematical Function
floor()
returns a rounded down number, which is less or equal to the parameter "number".
Syntax of the Mathematical Function floor()
The parameter "number" of the Mathematical Function floor()
number
The parameter "number" is a placeholder for
column names,
variables
or
constants,
which have to be available in the datatypes
float,
real or
double precision
. Additionally, the parameter recognises every other datatype which can be converted into any of the required datatypes using
implicit conversion
.
Example for the Mathematical Function floor()
select floor(124.35)
go
-----
124
Returns 124.
select floor(124.78)
go
-----
124
Returns 124.
select floor(-124.35)
go
-----
-125
Retunrs -125.
select floor(-124.78)
go
-----
-125
Returns -125.
select floor($124.78)
go
-----
124.00
Returns 124.00.
See also:
ASE T-SQL - Aggregate Functions,
Mathematical Functions,
abs(),
acos(),
asin(),
atan(),
atn2(),
ceiling(),
cos(),
cot(),
degrees(),
exp(),
log(),
log10(),
pi(),
power(),
radians(),
rand(),
round(),
sign(),
sin(),
sqrt(),
tan().
|
