🐛 Bug: PostgreSQL column of type date is misinterpreted for dates < 0100-01-01

[salim-b]

Please confirm if bug report does NOT exist already ?

• I confirm there is no existing issue for this

Steps to reproduce ?

PostgreSQL's date column type supports dates from 4713 BC to 5874897 AD. But dates before 0100-01-01 in an external PostgreSQL DB are wrongly displayed in NocoDB (as 1901-01-01) and values before 0100-01-01 are wrongly written from NocoDB (e.g. 0099-01-01 wrongly becomes 1999-01-01).

Desired Behavior

NocoDB should properly support date fields in external PostgreSQL DB's.

Project Details

Node: v20.12.1
Arch: x64
Platform: linux
Docker: false
RootDB: sqlite3
PackageVersion: 0.250.1

Attachments

No response