Enhance date fields in feature services to support millisecond

MateuszŻak — Fri, 16 Oct 2020 06:59:34 GMT

Enhance date fields in feature services to support millisecond resolution when adding, editing, or querying features.

We have feature service which writes date to MS SQL database, even thouth we have datetime2(7) data type fields, feature service writes only seconds. For example - when you try use aply edits operation and put 1543479941234 value to the datetime field, it will be cut to seconds, when you try to force service to write miliseconds (trying "DateTimeField" : "2020-10-06 11:11:11.34" ) it will bee decline by the server.

It is imposible to use ESRI Feature Service to work with highly accurate time data.

Re: Enhance date fields in feature services to support millisecond

Micah-JohnBeierle — Fri, 02 Jun 2023 11:57:53 GMT

We are observing the same issue on 10.9.1 Server on a 2019 SQL DB. It was found that a hosted feature service can be updated as expected; however, the featureServer Service from the SQL DB rounds to seconds. This limitation is unexpected. Due to the limitation and data use case we have had to add in separate seconds and nanoseconds attributes to capture the data feed. It appears that this defect has been persistent with no resolution and limited reasoning.

1) NIM096852 - Query operations using the time parameter are not adequately precise in the ArcGIS REST API.
2) BUG-000082768 : For the datetime(2) and datetime data types, the Date Field does not show data in milliseconds.
3) ENH-000104683 : Enhance date fields in feature services to support millisecond resolution when adding, editing, or querying features.

idea Enhance date fields in feature services to support millisecond in ArcGIS Rest APIs and Services Ideas

Enhance date fields in feature services to support millisecond

Re: Enhance date fields in feature services to support millisecond