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

snowflake.snowpark.functions.to_char¶

snowflake.snowpark.functions.to_char(c: ColumnOrName, format: ColumnOrLiteralStr | None = None) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.3.0/src/snowflake/snowpark/functions.py#L2179-L2201)¶

Converts a Unicode code point (including 7-bit ASCII) into the character that matches the input Unicode.

Example::

>>> df = session.create_dataframe([1, 2, 3, 4], schema=['a'])
>>> df.select(to_char(col('a')).as_('ans')).collect()
[Row(ANS='1'), Row(ANS='2'), Row(ANS='3'), Row(ANS='4')]

Example:

>>> import datetime
>>> df = session.create_dataframe([datetime.datetime(2023, 4, 16), datetime.datetime(2017, 4, 3, 2, 59, 37, 153)], schema=['a'])
>>> df.select(to_char(col('a')).as_('ans')).collect()
[Row(ANS='2023-04-16 00:00:00.000'), Row(ANS='2017-04-03 02:59:37.000')]