FW: [webmaster] Possible error in documentation for EXTRACT

Поиск

Список

Период

Сортировка

От	Mark Clark
Тема	FW: [webmaster] Possible error in documentation for EXTRACT
Дата	6 апреля 2016 г. 19:57:53
Msg-id	624ADA55-2C14-43E7-9A42-A84C425A24DE@enlightedinc.com обсуждение исходный текст
Ответы	Re: FW: [webmaster] Possible error in documentation for EXTRACT
Список	pgsql-docs

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

В списке pgsql-docs по дате отправления: