meta data for this page
  •  

F_FLOOR

input/output-compatibility to ib_udf

input/output-compatibility to rFunc (FLOOR)

Entrypoint f_floor compatible with UTF-8

Inputs/Outputs

   Input      DOUBLE      floatingpoint
   Output     DOUBLE      the largest integer less than or equal to input as a floatingpoint

Syntax

   Note differences from F_FLOOR, F_CEILING and F_TRUNCATE
   TestSQL
   SELECT 3.0 AS ISCORRECT, F_FLOOR(3.85), F_CEILING(3.85),F_TRUNCATE(3.85) FROM RDB$DATABASE;
   SELECT -4.0 AS ISCORRECT, F_FLOOR(-3.85), F_CEILING(-3.85),F_TRUNCATE(-3.85) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_FLOOR(NULL) FROM RDB$DATABASE;