Examples of the output from Time/Date Functions

Function Result

DAYOFMONTH('2022-12-03') 3

MONTH('2022-12-03') 12

YEAR('2022-12-03') 2022

HOUR('11:35:00') 11

MINUTE('11:35:00') 35

SECOND('11:35:00') 0

DAYOFWEEK('2022-12-03') 2

QUARTER('2022-12-03') 4

DAYOFYEAR('2022-12-03') 337

WEEK('2022-12-03') 48

LAST_DAY('2022-12-03') 31

DAYNAME('2022-12-03') Saturday

MONTHNAME('2022-12-03') December

In this example the dates are hardcoded, in reality the blue portion would be like what is shown below