Douglas Doole <dougdo...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers