Reference Guide
>
TDV Support for SQL Functions
>
Date Functions
>
DAYOFMONTH
DAYOFMONTH
Return the weekday name for a date or timestamp.
Syntax
DAYOFMONTH(date)
Example
SELECT DAYOFMONTH('2020-06-20');
The above query returns:
20