New answers tagged

0

These are the same values (as long as their Data Types are Date), and if I were you, I would not be worried about how they are presented if it is not really important. How ArcGIS uses the date field formats is explained in https://desktop.arcgis.com/en/arcmap/10.3/manage-data/tables/fundamentals-of-date-fields.htm, where it says: Settings on your Windows ...


1

A date stored in the database does not have a format, it is just a... date. What you see 'in SQL' is just a text representation of that date, which format may be determined by settings in the the database itself, or by whatever application you use to query the database. But that's just what you see on screen. Both ArcMap and ArcGIS Pro use the date format ...


4

A working sample import pandas as pd data = [{'mydate': '2007-02-01T05:00:00.0000000+00:00', 'b': 2, 'c':3}, {'mydate': '2007-02-01T05:00:00.0000000+00:00', 'b': 20, 'c': 30}] # Creates DataFrame. df = pd.DataFrame(data) # Below line commented to adopt simpler alternative # df['mydate'] = pd.to_datetime(df['mydate'], format="%Y-%m-%dT%H:%M:%...


Top 50 recent answers are included