idea Enhance date fields in feature services to support millisecond in ArcGIS Enterprise Ideas

Add millisecond support to Date fields stored Enterprise Geodatabases

ÁkosHalmai — Thu, 20 Jun 2019 17:02:46 GMT

Now, date fields in Enterprise Geodatabases can't handle millisecond values if the table/feature class is stored in MSSQL-based Enterprise Geodatabase. In field of geophysics this feature would be essential.

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: Add millisecond support to Date fields stored Enterprise Geodatabases

MateuszŻak — Tue, 22 Jun 2021 08:56:42 GMT

Similiar Idea

https://community.esri.com/ideas/19196

Re: Enhance date fields in feature services to support millisecond - Status changed to: In Product Plan

KoryKramer — Wed, 30 Aug 2023 12:47:15 GMT

Re: Enhance date fields in feature services to support millisecond - Status changed to: Implemented

KoryKramer — Mon, 18 Dec 2023 19:46:37 GMT

This Idea has been implemented in ArcGIS Pro 3.2. See the tool documentation here:https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/migratedatefieldtohighprecision.htm