News for hackers. Stuff that matters.
Re:Why is day of the month 1-indexed but the month is 0-inde... by CornCobs on Tuesday November 24, 2020 @03:22AM (#25196410)
I learnt this the hard way the other day that this is the case with Postgres too. Its very jarring in my opinion that we have to write date(1, 0, 2020) to mean 1st Jan - the date and year are fine but we suddenly need to minus one in the middle
Re:Why is day of the month 1-indexed but the month is 0-inde... by andreareina on Tuesday November 24, 2020 @06:35AM (#25197528)
Is make_date not available in your installation?

https://www.postgresql.org/docs/9.5/functions-datetime.html#...

Re:Why is day of the month 1-indexed but the month is 0-inde... by imglorp on Tuesday November 24, 2020 @04:05AM (#25196641)
One has to wonder how many gigajoules have been saved on Earth because of that one optimization. There are a lot of date columns out there.