Select to view content in your preferred language

Format esriFieldTypeDate from map service

2396
1
12-19-2017 07:34 AM
JamesCrandall
MVP Frequent Contributor

I'm querying against an ArcGIS Server feature service and need an assist to convert the date information being returned.  The feature class itself has editor tracking enabled and I'd like to format the last_edit_date value.

Description:

  {
   "name": "last_edited_date",
   "alias": "last_edited_date",
   "type": "esriFieldTypeDate",
   "length": 8
  }‍‍‍‍‍‍

Value:

"last_edited_date": 1512413066000

I'd like to take the value and apply this format: '%Y-%m-%d %H:%M:%S'

So far I'm not seeing any success with the various attempts:

#go thru the response
for feature in jsonResultApp['features']:
    lastEditDateStr = feature['attributes']['last_edited_date']
    dFormat = "%Y-%m-%d %H:%M:%S.%f"

    #all of these below fail with various errors
    #attempt 1
    lastEditDate = datetime.datetime.fromtimestamp(lastEditDateStr).strftime('%Y-%m-%d %H:%M:%S')
    #attempt 2
    lastEditDate = datetime.datetime.fromtimestamp(lastEditDateStr).strftime('%c')
    #attempt 3
    lastEditDate = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(lastEditDateStr))
    #attempt 4
    lastEditDate = datetime.datetime.strftime(d1, dFormat)‍‍‍‍‍‍‍‍‍‍‍‍‍‍
0 Kudos
1 Reply
JamesCrandall
MVP Frequent Contributor

I think this is close:

lastEditDateStr = feature['attributes']['last_edited_date']
s = lastEditDateStr/ 1000.0
dFormat = "%Y-%m-%d %H:%M:%S.%f"
d = datetime.datetime.fromtimestamp(s).strftime('%Y-%m-%d %H:%M:%S.%f')
                        ‍‍‍‍‍