Conversation

Hey, apparently Sweden is the only country in history with February 30th! nowiknow.com/february-30th/

Replying to

and

The question is, how do I enter that date into PostgreSQL?

Replying to

and

This may have some good ideas: vldb.org/conf/1993/P302

Replying to

and

Well, my point was that '1712-02-30'::date fails no matter what timezone is set, because we have hard-coded the 29-day assumption.

Replying to

and

I was half joking. Support for 30 day months for finance stuff happens to be part of the early history of Postgres + extensibility.