I have a table in SQL with one column TIMESTAMP which shows the date/time in the following format.
In order to process the data in ArcGIS, I created a new table in ArcGIS. To bring the Date/Time column I used the following code in Python.
arcpy.AddField_management(Track,'DT_start','DATE') # Add timing fields (Date/Time fields)
I get the date/time feature in "DT start" column in "Track" table in the following format.
When I load the output table back to SQL I get date/time in the following format.
How do I set the format in python code so that I get the date/time format in the same format as in the original table in SQL?
I would like to see the same format not only in ArcGIS output table but also when I load it back to SQL.
Is there any difference in the date/time format in ArcMap and ArcGIS Pro?