snowflake.snowpark.functions.dayofmonth¶

snowflake.snowpark.functions.dayofmonth(e: ColumnOrName) → Column[source]¶

Extracts the corresponding day (number) of the month from a date or timestamp.

Example::

CopyExpand

>>> import datetime
>>> df = session.create_dataframe(
...     [[datetime.datetime.strptime("2020-05-01 13:11:20.000", "%Y-%m-%d %H:%M:%S.%f")]],
...     schema=["a"],
... )
>>> df.select(dayofmonth("a")).collect()
[Row(DAYOFMONTH("A")=1)]

Show lessSee more

Scroll to top