How to get Day Name from date timestamp?

[helenaxysense]

Hi, 
Looking to get the filter to work but the only function I can find is DAYNAME which gives me Mon / Tue / Wed rather than the full day name.. As a result when filtering on a Day of Week date dimension group it is not working.. 

and ((DAYNAME(oph."DAY_LOCAL")) = 'Monday')

[anay · Accepted solution]

Is this in LookML? I don't recognize `dayname` as a standard sql function. `format_date` has a standard element for full name of day though:

format_date('%A', date '2023-01-01')

 (other standard sql format elements: https://cloud.google.com/bigquery/docs/reference/standard-sql/format-elements#format_elements_date_t...)