CODEWITHSUNDEEP
sqlpostgresql
Michi
Michi

Reputation: 5481

Get the number of the weekday from each date in a date list

DB-Fiddle

CREATE TABLE dates (
    date_list DATE
);

INSERT INTO dates
(date_list)
VALUES 
('2020-01-29'),
('2020-01-30'),
('2020-01-31'),
('2020-02-01'),
('2020-02-02');

Expected Results:

  Weekday
    2
    3
    4
    5
    6

I want go get the number of the weekday for each date in the table dates.
Therefore, I tried to go with the solution from this question but could not make it work:

SELECT 
EXTRACT(DOW FROM DATE d.date_list))
FROM dates d

How do I need to modify the query to get the expected result?

Upvotes: 0

Views: 149

Answers (1)

user330315
user330315

Reputation:

Get rid of the date keyword it is only needed to introduce a DATE constant. If you already have a DATE value (which your column is) it's not needed:

select extract(dow from d.date_list)
from dates d

Upvotes: 1

Related Questions