You are viewing documentation about an older version (1.9.0). View latest version

snowflake.snowpark.functions.floor¶

snowflake.snowpark.functions.floor(e: Union[Column, str]) → Column[source]¶

Returns values from the specified column rounded to the nearest equal or smaller integer.

Examples:

>>> df = session.create_dataframe([135.135, -975.975], schema=["a"])
>>> df.select(floor(df["a"]).alias("floor")).collect()
[Row(FLOOR=135.0), Row(FLOOR=-976.0)]

Copy