- Species Diversity
Issues with imported dates
Submitted by idfg-bthomas on July 11, 2013 - 12:06pm
- Dates with no year (1,702 observations). Since dates require years for these an arbitrary year of 1840 was assigned.
- Dates with no day were assigned to the 15th of the month
- Dates with no month and day were assigned to June 15th (I believe, Ben will have to confirm this)
Quirks I can't explain:
7 records (nid >530810 And nid <530817) converted 6/30/1993 to 6/30/1669fixed 7/11/13
There are no future dates in the database, and I'm not seeing the date shift described. Perhaps SQL Server doesn't know what to make of the date formats we are exporting and that is where the shift is happening on import? Perhaps we need to tweak the date export format so SQL Server can parse?