Re: FW: [webmaster] Possible error in documentation for EXTRACT

On Wed, 2016-04-06 at 17:05 +0000, Mark Clark wrote:
> 
> TWIMC,
>            In the documentation for 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(dot)clark(at)enlightedinc(dot)com

$ psql test
Timing is on.
psql (9.5.2)
Type "help" for help.

test=# SELECT EXTRACT(CENTURY FROM TIMESTAMP '2001-02-16 20:38:40');
 date_part 
-----------
        21
(1 row)

Time: 1.336 ms
test=# 

the 21st century began on 2001-01-01.