AnsweredAssumed Answered

Stand-Alone Python Script - Date Field Modification

Question asked by ModernGIS on Jun 20, 2019
Latest reply on Jun 20, 2019 by ModernGIS

I've been doing alot of research on how to accomplish a specific task and from what I can tell, it seems to frustrate many people and I am really starting to agree.

I am developing a series of Python Scripts (converting from data models) to import reading data and dates to prepare for our GIS database. One of the tasks in the series is dealing with the date field(s). The raw data for the READING_DATE field (Date Type) comes in as m-d-y-h-m-s (Ex. 1/1/2019 12:10:00). I need to go from this format to a format of m-y (Ex. Jan-2019). I am not sure exactly how to do this. In my data model, I use the Convert Time Field tool. However, when running this tool on over 500,000 records it takes a LONG time. 

I am thinking about using the Arcpy Update Cursor but still new to using this feature. Would like some help in how to set-up the script code and exactly what field type(s) I need to accomplish this.  

Thank You

Outcomes