The following bug has been logged online: Bug reference: 2482 Logged by: Alexander Galler Email address: [EMAIL PROTECTED] 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" ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster