snowflake.snowpark.functions.date_format¶

snowflake.snowpark.functions.date_format(c: Union[Column, str], fmt: Union[Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.47.0/src/snowflake/snowpark/functions.py#L4103-L4155)¶

Converts an input expression into the corresponding date in the specified date format.

Example::

>>> df = session.create_dataframe([("2023-10-10",), ("2022-05-15",), ("invalid",)], schema=['date'])
>>> df.select(date_format('date', 'YYYY/MM/DD').as_('formatted_date')).show()
--------------------
|"FORMATTED_DATE"  |
--------------------
|2023/10/10        |
|2022/05/15        |
|NULL              |
--------------------

Example::

>>> df = session.create_dataframe([("2023-10-10 15:30:00",), ("2022-05-15 10:45:00",)], schema=['timestamp'])
>>> df.select(date_format('timestamp', 'YYYY/MM/DD HH:mi:ss').as_('formatted_ts')).show()
-----------------------
|"FORMATTED_TS"       |
-----------------------
|2023/10/10 15:30:00  |
|2022/05/15 10:45:00  |
-----------------------

Example::

>>> df = session.sql("select '2023-10-10'::DATE as date_col, '2023-10-10 15:30:00'::TIMESTAMP as timestamp_col")
>>> df.select(
...     date_format('date_col', 'YYYY/MM/DD').as_('formatted_dt'),
...     date_format('timestamp_col', 'YYYY/MM/DD HH:mi:ss').as_('formatted_ts')
... ).show()
----------------------------------------
|"FORMATTED_DT"  |"FORMATTED_TS"       |
----------------------------------------
|2023/10/10      |2023/10/10 15:30:00  |
----------------------------------------