Postgres: Error converting date in Postgres 10

Question

When I perform a date conversion on postgres 9.6 that I have on my machine, it fixes the date if it is invalid, the same is not happening on postgres 10 that is on another machine:

Postgres 9.6

Datestyle = ISO, DMY
server_encoding = UTF8
Timezone = America/Sao_paulo

SELECT to_timestamp('01/12/2018 24:00:00', 'dd/MM/yyyy HH24/MI/SS')
  Resultado: 02/12/2018 00:00:00
SELECT to_timestamp('31/11/2018 00:00:00', 'dd/MM/yyyy HH24/MI/SS')
  Resultado: 01/12/2018 00:00:00

Postgres 10

Datestyle = ISO, DMY
server_encoding = UTF8
Timezone = America/Sao_paulo

SELECT to_timestamp('01/12/2018 24:00:00', 'dd/MM/yyyy HH24/MI/SS')
  ERROR: date/time field value out of range: "01/12/2018 24:00:00"
SELECT to_timestamp('31/11/2018 00:00:00', 'dd/MM/yyyy HH24/MI/SS')
  ERROR: date/time field value out of range: "31/12/2018 00:00:00"

Any clue as to what the difference between the banks might be ?

EDIT: Here’s some information on how it should work: http://www.postgresqltutorial.com/postgresql-to_timestamp/#Crayon-5c2381f372207739024582

Answer 1

Because as of version 10 you have rejected invalid dates. See Release Notes (Appendix E):

https://www.postgresql.org/docs/current/release-10.html

E.9.3.6. Functions

Make to_timestamp() and to_date() Reject out-of-range input Fields (Artur Zakirov)