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