ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB:
When importing a .CSV into an enterprise geodatabase as a standalone table:
There are dates stored as text like this in the CSV (8 fields):
- Nov 7, 2023, 9:55 AM
- Sep 23, 2022, 1:11 PM
- May 9, 2023, 6:56 AM
As part of the import process (Table to Geodatabase), I want to translate the text to true date values so that they can be loaded into date fields in the EGDB table. I want to do this in a single tool. For example, in Table to Geodatabase, there would be a list of fields, and I'd load a field calculator script, arcade expression, or SQL field expression into each field that needs to be translated.
Otherwise, it is unnecessarily cumbersome to load data into a table if the data needs to be translated first.
