Open Date - Caching a CSV - Date fields that are blank/or Null filled with a value 1-1-1970?

116
1
10-29-2020 10:00 PM
IanMooser1
New Contributor

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

1 Reply
IanMooser1
New Contributor

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

0 Kudos