snowflake.snowpark.functions.as_number¶
- snowflake.snowpark.functions.as_number(variant: Union[Column, str], precision: Optional[int] = None, scale: Optional[int] = None) Column[source]¶
Casts a VARIANT value to a fixed-point decimal (does not match floating-point values).
- Example::
>>> df = session.sql("select 1.2345::variant as a") >>> df.select(as_number("a", 4, 1).alias("result")).show() ------------ |"RESULT" | ------------ |1.2 | ------------