TWIMC, In the documentation for EXTRACT<http://www.postgresql.org/docs/9.5/interactive/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT>, the example for “century" is as follows:
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 I believe the result for the second SELECT is incorrect. I believe it should be: SELECT EXTRACT(CENTURY FROM TIMESTAMP '2001-02-16 20:38:40'); Result: 20 Alternatively, you could change the example to: SELECT EXTRACT(CENTURY FROM TIMESTAMP '2100-02-16 20:38:40'); Result: 21 If I have missed some point about how this should work, then please ignore this e-mail. Thanks, Mark Clark mark.cl...@enlightedinc.com