DAY (Lakehouse v2)

Returns the day of the month from a date.

Analyze Syntax

func.day(<date>)

Analyze Examples

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

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

SQL Syntax

DAY(<date>)

SQL Examples

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

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