Wrong timestamp to date cast for dates predating 1970-01-01

[lukaseder]

Describe the problem

When casting a timestamp before 1970-01-01 to date, a wrong result is produced

To Reproduce

Run this SQL query in PostgreSQL and CockroachDB:

select ts, ts::date
from (values 
  (timestamp '1969-12-30 01:00:00'),
  (timestamp '1970-12-30 01:00:00')
) t (ts);

The expected result (as observed in PostgreSQL) is that both timestamps are truncated to December 30:

ts	ts
1969-12-30 01:00:00	1969-12-30
1970-12-30 01:00:00	1970-12-30

However, in CockroachDB, I'm getting:

ts	ts
1969-12-30 01:00:00	1969-12-31
1970-12-30 01:00:00	1970-12-30

I'm using:

show timezone;

Europe/Berlin

Environment:

• CockroachDB version: CockroachDB CCL v19.2.1 (x86_64-unknown-linux-gnu, built 2019/11/18 23:23:55, go1.12.12)
• Server OS: Linux on Docker on Windows
• Client app: JDBC