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.clark@enlightedinc.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.