gzh schrieb am 17.05.2022 um 17:55:
I have had a Perl Website working for 7 years and have had no problems
until at the weekend I replace my database server with a newer one.
Database server (old): PostgreSQL 8.2 32bit
Database server (new): PostgreSQL 9.4 64bit
I run following sql in PostgreSQL 8.2, it return my expected result as
‘YYYY-MM-DD’ format.
--PostgreSQL 8.2
---------------
SELECT to_date(now() + '-7day', 'YYYY-MM-DD');
Calling to_date() on a value that is already a date or timestamp value is a
huge mistake to begin with (and as you found out a bug waiting to happen).
That should have been current_date + 7 from day one.
