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:
<SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"name"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"last_edited_date"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"alias"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"last_edited_date"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"type"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"esriFieldTypeDate"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"length"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">8</SPAN>
<SPAN class="punctuation token">}</SPAN>Value:
<SPAN class="string token">"last_edited_date"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">1512413066000</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN></SPAN>
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:
<SPAN class="comment token">#go thru the response</SPAN>
<SPAN class="keyword token">for</SPAN> feature <SPAN class="keyword token">in</SPAN> jsonResultApp<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'features'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
lastEditDateStr <SPAN class="operator token">=</SPAN> feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'last_edited_date'</SPAN><SPAN class="punctuation token">]</SPAN>
dFormat <SPAN class="operator token">=</SPAN> <SPAN class="string token">"%Y-%m-%d %H:%M:%S.%f"</SPAN>
<SPAN class="comment token">#all of these below fail with various errors</SPAN>
<SPAN class="comment token">#attempt 1</SPAN>
lastEditDate <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>fromtimestamp<SPAN class="punctuation token">(</SPAN>lastEditDateStr<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'%Y-%m-%d %H:%M:%S'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#attempt 2</SPAN>
lastEditDate <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>fromtimestamp<SPAN class="punctuation token">(</SPAN>lastEditDateStr<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'%c'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#attempt 3</SPAN>
lastEditDate <SPAN class="operator token">=</SPAN> time<SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'%Y-%m-%d %H:%M:%S'</SPAN><SPAN class="punctuation token">,</SPAN> time<SPAN class="punctuation token">.</SPAN>localtime<SPAN class="punctuation token">(</SPAN>lastEditDateStr<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#attempt 4</SPAN>
lastEditDate <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN>d1<SPAN class="punctuation token">,</SPAN> dFormat<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN></SPAN>