SELECT EXTRACT(CENTURY FROM TIMESTAMP '2000-12-16 12:21:13'); Result: 20 SELECT EXTRACT(CENTURY FROM TIMESTAMP '2001-02-16 20:38:40'); Result: 21
SELECT EXTRACT(CENTURY FROM TIMESTAMP '2001-02-16 20:38:40'); Result: 20
SELECT EXTRACT(CENTURY FROM TIMESTAMP '2100-02-16 20:38:40'); Result: 21
pgsql-docs by date:
Соглашаюсь с условиями обработки персональных данных