Day of Week (text) | DATE_DAY_OF_WEEK_STRING

Syntax

DATE_DAY_OF_WEEK_STRING( [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 a TEXT.

Description

Get the day of week of a DATE as a TEXT.

Examples

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