DATE_PART('field', INTERVAL) not intuitive literal reading of interval

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: vodevsh(at)gmail(dot)com
Subject: DATE_PART('field', INTERVAL) not intuitive literal reading of interval
Date: 2018-05-22 10:55:14
Message-ID: 152698651482.26744.15456677499485530703@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/static/functions-datetime.html
Description:

the result of
t=# SELECT DATE_PART('month', '2018-05-31'::timestamp -
'2018-02-24'::timestamp);
date_part
-----------
0
(1 row)

looks correct, but not intuitive, maybe we need a NB for:

t=# SELECT DATE_PART('month', justify_interval('2018-05-31'::timestamp -
'2018-02-24'::timestamp));
date_part
-----------
3
(1 row)

https://stackoverflow.com/questions/50465632/postgresql-10-4-date-difference/50465676#50465676

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Anna Akenteva 2018-05-23 15:33:43 [DOCS] Let's document a bytea bug
Previous Message Pantelis Theodosiou 2018-05-19 11:05:26 Re: Changes in serial / sequence introduced in Postgresql 10