DAYOFMONTH (Lakehouse v2)

Returns the day of the month from a date. Alias for DAY.

Analyze Syntax

func.dayofmonth(<date>)

Analyze Examples

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

┌────┐
│ 15  │
└────┘

SQL Syntax

DAYOFMONTH(<date>)

SQL Examples

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

┌────┐
│ 15  │
└────┘