We see a pattern with date fields and the cached CSV files at our open data site.
The issue is with blank and Null date fields being populated in CSV cached file.
For example - this service has BSL_FNL_ACPTNC_DATE - 'Final Acceptance Date.'
Data page sorted by date(to show blank values) - DWW Swales
I attached a file from the cached CSV file > https://opendata.arcgis.com/datasets/17ed919de3f149b48e3bdcb72fc97cf2_10.csv
In BSL_FNL_ACPTNC_DATE field in the downloaded CSV - we now see values created for our Null values '1970/01/01 00:00:00+00'
Has anyone seen this behavior - as it has caused noticeable issues with datasets that a local paper uses, and just in general, this behavior is not what we expect or desire?
Thank You
We work with ESRI in our case please refer to this BUG-000136293 - especially consider if Oracle is in your stack, you note it is UNIX time - Epoch time