Douglas Doole <dougdoole@gmail.com> writes:
> I was playing with TO_TIMESTAMP() and I noticed a weird result:
> postgres=# select to_timestamp('20170-07-24 21:59:57.12345678', 'yyyy-mm-dd
> hh24:mi:ss.us');
> to_timestamp
> --------------------------------
> 20170-07-24 22:00:09.345678+00
> (1 row)
FWIW, we already tightened that up in v10:
regression=# select to_timestamp('20170-07-24 21:59:57.12345678', 'yyyy-mm-dd hh24:mi:ss.us');
ERROR: date/time field value out of range: "20170-07-24 21:59:57.12345678"
There may well be some discrepancies left.
regards, tom lane