You are viewing documentation about an older version (1.12.1). 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