Funnily enough I was having a conversation with my wife on exactly this as I
opened your email.
If the Wikipedia article is to be trusted, the following seems fitting:
SELECT EXTRACT(ORDINAL DECADE FROM '2020-01-01'::date);
date_part
---
201
And the default:
SELECT
>> On Saturday, 26 January 2019, 16:00:24 GMT, Tom Lane
wrote: >>
>> I'm thinking we should regretfully retire opossum, unless there's
>> a software update available for it that fixes this bug.
I'm happy to update opossum to see if the issue goes away; likewise I'm just as
happy to retire it
