DAYOFMONTH
Learn how to use the DAYOFMONTH date/time function in PlaidCloud Lakehouse. Returns the day of the month from a date. Alias for
DAY.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 │
└────┘