I want to derive a column for day of week for a time value. There are DAY_OF_MONTH
and DAY_OF_YEAR
functions in Contour, but not one for day of week.
How can I derive the day of the week using Contour?
I want to derive a column for day of week for a time value. There are DAY_OF_MONTH
and DAY_OF_YEAR
functions in Contour, but not one for day of week.
How can I derive the day of the week using Contour?
There is currently no DAY_OF_WEEK
function, but you can use this workaround:
date_format("<NameOfYourDateColumn>", 'EEE')