"Alexander Galler" <[EMAIL PROTECTED]> writes:
> select '20.01.01 BC'::timestamp;
> Result:
> "2020-01-01 00:00:00 BC"
> I want "20-01-01 00:00:00 BC"
You can write
select '0020.01.01 BC'::timestamp;
I agree it seems like a bug that the 'yy'->'20yy' conversion is applied
to BC dates. The code appears to try to avoid that, but I think it's
confused in this case because 'BC' hasn't been scanned yet.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
