Day of Week (number) | DATE_DAY_OF_WEEK

Syntax

DATE_DAY_OF_WEEK( [value = CURRENT_DATE()] )

Parameters

value
A DATE value. If the value is not a DATE, it will be converted to one with the DATE operation.

Return Value

Returns the UTC date value of the VALUE as an INTEGER where 1 is Monday and 7 is Sunday.

Description

Get the day of week of a DATE

Examples

DATE_DAY_OF_WEEK("2017-08-30T17:36:23.000Z") # returns 3