I'm on ArcGIS Pro 3.1 and have created a stand alone python script to import data from an outside SQL table with Lat/Long fields into a file GDB feature class using the XYTableToPoint method and an extracted CSV. The issue is it fails converting all of the data fields as dates. Unfortunately the table I am extracting from has multiple date fields as different data types. The first one is a smalldatetime and the rest are datetime. (it's not mine, I cant change it and I didn't create it)
When extracted to CSV and then converted to a table in the FGDB, it successfully converts the smalldatetime to a date field, but the other ones it imports as TEXT fields. I cannot see a difference between any of these fields when looking at he raw CSV data.
I have added a SQL CAST into the extraction script to cast all of the datetime fields into smalldatetime and that works for the very first one, but it ignores the rest of them (no matter what field I put first).
Am I running into a bug here?
