DOW is 0-based? - Mailing list pgsql-general

From Igal @ Lucee.org
Subject DOW is 0-based?
Date
Msg-id 860b4e3a-b157-8a70-8a5b-deb4a61e1494@lucee.org
Whole thread Raw
Responses Re: DOW is 0-based?  (Igor Korot <ikorot01@gmail.com>)
Re: DOW is 0-based?  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general

Is there a rational reason why Day of the Week is 0-based, i.e. Sunday (0) to Saturday (6) instead of the more intuitive Sunday (1) to Saturday (7)?

    SELECT date_part('dow', current_date);

https://www.postgresql.org/docs/current/static/functions-datetime.html

Thanks,

Igal Sapir
Lucee Core Developer
Lucee.org

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Odd behavior with 'currval'
Next
From: Igor Korot
Date:
Subject: Re: DOW is 0-based?