https://community.esri.com/t5/data-management-ideas/enhance-date-fields-in-feature-services-to-support/idi-p/932973 <P><SPAN>Enhance date fields in feature services to support millisecond resolution when adding, editing, or querying features.&nbsp;</SPAN></P><P>&nbsp;</P><P><SPAN>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&nbsp;<SPAN>1543479941234&nbsp; value to the datetime field, it will be cut to seconds, when you try to force service to write miliseconds (trying&nbsp;<SPAN>"DateTimeField" : "2020-10-06 11:11:11.34"&nbsp;) it will bee decline by the server.&nbsp;</SPAN></SPAN></SPAN></P><P><SPAN><SPAN>It is imposible to use ESRI Feature Service to work with highly accurate time data.&nbsp;</SPAN></SPAN></P> Tue, 18 Oct 2022 22:47:30 GMT MateuszŻak 2022-10-18T22:47:30Z https://community.esri.com/t5/data-management-ideas/enhance-date-fields-in-feature-services-to-support/idi-p/932973 <P><SPAN>Enhance date fields in feature services to support millisecond resolution when adding, editing, or querying features.&nbsp;</SPAN></P><P>&nbsp;</P><P><SPAN>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&nbsp;<SPAN>1543479941234&nbsp; value to the datetime field, it will be cut to seconds, when you try to force service to write miliseconds (trying&nbsp;<SPAN>"DateTimeField" : "2020-10-06 11:11:11.34"&nbsp;) it will bee decline by the server.&nbsp;</SPAN></SPAN></SPAN></P><P><SPAN><SPAN>It is imposible to use ESRI Feature Service to work with highly accurate time data.&nbsp;</SPAN></SPAN></P> Tue, 18 Oct 2022 22:47:30 GMT https://community.esri.com/t5/data-management-ideas/enhance-date-fields-in-feature-services-to-support/idi-p/932973 MateuszŻak 2022-10-18T22:47:30Z https://community.esri.com/t5/data-management-ideas/enhance-date-fields-in-feature-services-to-support/idc-p/1223107#M2000 <P>This idea has been closed as it is a duplicate of an idea on the Enterprise Geodatabase Ideas Exchange.&nbsp; If you'd like to show it some support, follow the link below to the active idea and give it a thumbs up there!<BR /><BR /></P><P><A href="https://community.esri.com/t5/arcgis-enterprise-ideas/enhance-date-fields-in-feature-services-to-support/idi-p/942501" target="_blank">https://community.esri.com/t5/arcgis-enterprise-ideas/enhance-date-fields-in-feature-services-to-support/idi-p/942501</A></P> Tue, 18 Oct 2022 22:42:53 GMT https://community.esri.com/t5/data-management-ideas/enhance-date-fields-in-feature-services-to-support/idc-p/1223107#M2000 SSWoodward 2022-10-18T22:42:53Z