topic Arcpy da insertcursor and date time fields in Data Management Questions https://community.esri.com/t5/data-management-questions/arcpy-da-insertcursor-and-date-time-fields/m-p/279229#M16051 <HTML><HEAD></HEAD><BODY><P>i need to add new rows to&nbsp;a table in a file geodatabase using python (da.insertcursor). One of the fields that I am &nbsp;adding data to is a datetime. The insert operation functions correctly except for the fact that the time component is always omitted in the resulting datetime firks. I understand that shape files only store dates but that this doesn't apply to file geodatabases. I verified this by manually adding an entry in ArcGIS with a time component; this worked fine. I have checked the datetime variable that I create and pass in python and it includes all data as expected. Has anyone else had trouble with this? Is there a workaround?</P></BODY></HTML> Wed, 19 Oct 2016 21:14:26 GMT DeanMcGowan 2016-10-19T21:14:26Z Arcpy da insertcursor and date time fields https://community.esri.com/t5/data-management-questions/arcpy-da-insertcursor-and-date-time-fields/m-p/279229#M16051 <HTML><HEAD></HEAD><BODY><P>i need to add new rows to&nbsp;a table in a file geodatabase using python (da.insertcursor). One of the fields that I am &nbsp;adding data to is a datetime. The insert operation functions correctly except for the fact that the time component is always omitted in the resulting datetime firks. I understand that shape files only store dates but that this doesn't apply to file geodatabases. I verified this by manually adding an entry in ArcGIS with a time component; this worked fine. I have checked the datetime variable that I create and pass in python and it includes all data as expected. Has anyone else had trouble with this? Is there a workaround?</P></BODY></HTML> Wed, 19 Oct 2016 21:14:26 GMT https://community.esri.com/t5/data-management-questions/arcpy-da-insertcursor-and-date-time-fields/m-p/279229#M16051 DeanMcGowan 2016-10-19T21:14:26Z Re: Arcpy da insertcursor and date time fields https://community.esri.com/t5/data-management-questions/arcpy-da-insertcursor-and-date-time-fields/m-p/279230#M16052 <HTML><HEAD></HEAD><BODY><P>There is a working example in <A _jive_internal="true" href="https://community.esri.com/thread/184013-calculate-date-field">this thread</A>. The main trick is to use <A href="https://docs.python.org/2/library/datetime.html#strftime-and-strptime-behavior">datetime.datetime.strptime()</A>, but it sounds like you've already correctly made a datetime object. Can you post the relevant code?</P></BODY></HTML> Wed, 19 Oct 2016 21:21:02 GMT https://community.esri.com/t5/data-management-questions/arcpy-da-insertcursor-and-date-time-fields/m-p/279230#M16052 DarrenWiens2 2016-10-19T21:21:02Z Re: Arcpy da insertcursor and date time fields https://community.esri.com/t5/data-management-questions/arcpy-da-insertcursor-and-date-time-fields/m-p/279231#M16053 <HTML><HEAD></HEAD><BODY><P>Thanks for the quick help. Using the link you posted I was able to get things running! Now I just have to wait while 72mil rows are added...</P></BODY></HTML> Thu, 20 Oct 2016 07:12:09 GMT https://community.esri.com/t5/data-management-questions/arcpy-da-insertcursor-and-date-time-fields/m-p/279231#M16053 DeanMcGowan 2016-10-20T07:12:09Z