'How to convert date into day of the week in BigQuery?

I have a column of dates and I was wondering how I could add another column to show the day of the week?

Screenshot of data

sqldategoogle-bigquery


Solution 1:[1]

see below example

select 
  extract(dayofweek from date('2022-03-02')) as dayofweek_as_number,
  format_date('%a', date('2022-03-02')) as dayofweek_abbreviated,
  format_date('%A', date('2022-03-02')) as dayofweek_fullname

with output

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Mikhail Berlyant

Related Questions