DAYOFMONTH (Lakehouse v2)
Returns the day of the month from a date. Alias for DAY.
Analyze Syntax
Section titled “Analyze Syntax”func.dayofmonth(<date>)Analyze Examples
Section titled “Analyze Examples”func.dayofmonth('2024-06-15')
┌────┐│ 15 │└────┘SQL Syntax
Section titled “SQL Syntax”DAYOFMONTH(<date>)SQL Examples
Section titled “SQL Examples”SELECT DAYOFMONTH('2024-06-15');
┌────┐│ 15 │└────┘