idea Query date fields of feature services using unix timestamps in ArcGIS Rest APIs and Services Ideas https://community.esri.com/t5/arcgis-rest-apis-and-services-ideas/query-date-fields-of-feature-services-using-unix/idi-p/940250 <HTML><HEAD></HEAD><BODY><DIV>As a geospatial engineer</DIV><DIV>I want to filter all date fields using UNIX timestamps like it is expected by the time instant and time extent parameters.</DIV><DIV>So that, I can easily query and filter the features using UNIX timestamps without validating any security issues related to SQL injection by using DATE and TIMESTAMP expressions.</DIV><DIV></DIV><DIV>Currently, we have to use the DATE and TIMESTAMP expressions. Please, show some love to the query capabilities of the REST API.</DIV><P></P><DIV><SPAN>event_date=TIMESTAMP</SPAN><SPAN> </SPAN><SPAN>'2020-02-29</SPAN><SPAN> </SPAN><SPAN>00:00:00' =&gt; Succeeded</SPAN></DIV><DIV></DIV><DIV><DIV style="color: #ec8f45;"><STRONG>event_date=1582934400 =&gt; Failed</STRONG></DIV></DIV></BODY></HTML> Thu, 29 Oct 2020 14:10:32 GMT Jan-Tschada 2020-10-29T14:10:32Z Query date fields of feature services using unix timestamps https://community.esri.com/t5/arcgis-rest-apis-and-services-ideas/query-date-fields-of-feature-services-using-unix/idi-p/940250 <HTML><HEAD></HEAD><BODY><DIV>As a geospatial engineer</DIV><DIV>I want to filter all date fields using UNIX timestamps like it is expected by the time instant and time extent parameters.</DIV><DIV>So that, I can easily query and filter the features using UNIX timestamps without validating any security issues related to SQL injection by using DATE and TIMESTAMP expressions.</DIV><DIV></DIV><DIV>Currently, we have to use the DATE and TIMESTAMP expressions. Please, show some love to the query capabilities of the REST API.</DIV><P></P><DIV><SPAN>event_date=TIMESTAMP</SPAN><SPAN> </SPAN><SPAN>'2020-02-29</SPAN><SPAN> </SPAN><SPAN>00:00:00' =&gt; Succeeded</SPAN></DIV><DIV></DIV><DIV><DIV style="color: #ec8f45;"><STRONG>event_date=1582934400 =&gt; Failed</STRONG></DIV></DIV></BODY></HTML> Thu, 29 Oct 2020 14:10:32 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-ideas/query-date-fields-of-feature-services-using-unix/idi-p/940250 Jan-Tschada 2020-10-29T14:10:32Z