snowflake.snowpark.functions.as_decimal¶
- snowflake.snowpark.functions.as_decimal(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_decimal("a", 4, 1).alias("result")).show() ------------ |"RESULT" | ------------ |1.2 | ------------