Convert Time Field

02-07-2014 03:10 AM
New Contributor II
This tool seems very strait forward but is causing issues when put into python. Works fine in ArcMap and I get the expected results.

My Input Time Field(Text Field) looks like:
2014-02-01 02:11 AM

inputTimeField = "Incident_Date___Time"
inputTimeFormat = "1033;yyyy-MM-dd HH:mm tt"
outputDateField = "IncDateTime"                      

After the tool is run the IncDateTime Field comes back as:

Am I missing something here?
Tags (2)
0 Kudos
3 Replies
Esri Esteemed Contributor
Hi Adam,

A good trick to get the syntax correct is to run the tool in ArcMap, then open the Results window (Geoprocessing menu > Results).  Right-click on the completed tool > Copy As Python Snippet.  You can then paste this into your script.
New Contributor III
I would suggest looking at the python datetime module.  It will do anything you can think of for manipulating date and time values.
0 Kudos
New Contributor III
Just a word of warning In a file geodatabase the date and times are all stored as unicode strings, and you need to specify that when manipulating them with Python.
  time_value.encode('utf-8'), "%d/%m/%Y %I:%M:%S %p") 
0 Kudos