3 ms·

> 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. Th

by XYen0n 3mo ago

> 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 century to 1 century. If you disagree with this, please write your complaint to: Pope, Cathedral Saint-Peter of Roma, Vatican. https://www.postgresql.org/docs/9.0/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT https://www.postgresql.org/docs/9.0/functions-datetime.html#...

benj111 3mo ago
00:00:00? Surely 12:00:00 or 24:00:00?
- throw1234567891 3mo ago
  00:00:00, there is no time such as 24:00:00. There could be 23:59:59, then 00:00:00.
  - IAmBroom 3mo ago
    And 12:00:00 is noon, which no one ever wanted for a calendar day change.
    - benj111 3mo ago
      12:00am midnight on a 12 hour clock.
  - benj111 3mo ago
    I've always seen it formatted as 24:00 to clarify it's 24 hour format and to mirror 12 hour time.
ButlerianJihad 3mo ago
It may surprise you or the PGSQL devs to learn that St. Peter's Basilica is not a cathedral at all! And while Vatican City is surrounded and enclosed by the city of Rome, you shouldn't need to put "Roma" in an address if it's destined for the sovereign nation of Vatican City. Your mail may arrive despite the silly addressing, but church buildings are not actually the places with mailboxes and postal routes. Okay, okay, it's a joke! I get it!