The following bug has been logged online:
Bug reference: 2482
Logged by: Alexander Galler
Email address: galler(at)kuzbass(dot)net
PostgreSQL version: 8.1.3
Operating system: Windows XP
Description: Wrong result in timestamp_in, timestamptz_in, date_in
Details:
SET SESSION DateStyle TO ISO, YMD;
select '20.01.01 BC'::timestamp;
Result:
"2020-01-01 00:00:00 BC"
I want "20-01-01 00:00:00 BC"
select '20.01.01 BC'::timestamptz
Result:
"2020-01-01 00:00:00+06:11 BC"
I want "20-01-01 00:00:00+06:11 BC"
select '20.01.01 BC'::date
Result:
"2020-01-01 BC"
I want "20-01-01 BC"