snowflake.snowpark.functions.month¶
- snowflake.snowpark.functions.month(e: Union[Column, str]) Column [source]¶
Extracts the month from a 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(month("a")).collect() [Row(MONTH("A")=5), Row(MONTH("A")=8)]