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

snowflake.snowpark.functions.monthname¶

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

Extracts the three-letter month name from the specified date or timestamp.

Example:

>>> import datetime
>>> df = session.create_dataframe([
...     datetime.datetime.strptime("2020-05-01 13:11:20.000", "%Y-%m-%d %H:%M:%S.%f"),
...     datetime.datetime.strptime("2020-08-21 01:30:05.000", "%Y-%m-%d %H:%M:%S.%f")
... ], schema=["a"])
>>> df.select(monthname("a")).collect()
[Row(MONTHNAME("A")='May'), Row(MONTHNAME("A")='Aug')]
Copy