The Century SQL Complaint

century The century SELECT EXTRACT(CENTURY FROM TIMESTAMP '2000-12-16 Result: 20 SELECT EXTRACT(CENTURY FROM TIMESTAMP '2001-02-16 Result: 21 The first century starts at 0001-01-01 00:00:00 AD, although they did not know it at the time. This definition applies to all Gregorian calendar countries. There is no century number 0, you go from -1 to 1. If you disagree with this, please write your complaint to: Pope, Cathedral Saint-Peter of Roma, Vatican.

A dark-themed programming screenshot shows PostgreSQL-style SQL queries extracting the century from two timestamps, followed by an explanation of Gregorian century numbering. The joke is that there is no century 0, so anyone disputing the convention should complain to the Pope at Saint Peter’s Cathedral in the Vatican. It is used as a dry reaction to pedantic arguments about dates, numbering, or arbitrary standards.

• @dev_meme / 6269 2024-09-25