DAYOFMONTH

Return the weekday name for a date or timestamp.

Syntax

DAYOFMONTH(date)

Example

SELECT DAYOFMONTH('2020-06-20');

The above query returns:

20