MONTHNAME (Lakehouse v2)

Returns the name of the month for a date.

Analyze Syntax

func.monthname(<date>)

Analyze Examples

func.monthname('2024-06-15')

┌────────┐
│ 'June'  │
└────────┘

SQL Syntax

MONTHNAME(<date>)

SQL Examples

SELECT MONTHNAME('2024-06-15');

┌──────┐
│ June  │
└──────┘