topic ESRI Edit Service does not honour milliseconds in Implementing ArcGIS Questions https://community.esri.com/t5/implementing-arcgis-questions/esri-edit-service-does-not-honour-milliseconds/m-p/356081#M329 <HTML><HEAD></HEAD><BODY><P>Using ESRI 10.5.1 Enterprise geodatabase SQL Server 2016</P><P>I have a layer with a field'START_STAMP' defined as datetime2(7)</P><P>Using an ESRI Edit Service I insert a row specifying an attribute as</P><P><SPAN style="color: #1f497d; font-size: 11pt;">"START_STAMP": 1543479941234</SPAN></P><P>I then use the same EDIT Service to retrieve the row and the attribute shows as</P><P><SPAN style="color: #1f497d; font-size: 11pt;">"START_STAMP": 1543479941000</SPAN></P><P></P><P>IE the timestamp has been truncated to the nearest second.</P><P></P><P>This is not the behavior I wanted (or expected)</P><P></P><P>Is there any way that I can avoid the truncation, or do I have to live in a world where a second is as close as I can get to the time?</P></BODY></HTML> Mon, 10 Dec 2018 05:48:58 GMT JohnCuthbertson1 2018-12-10T05:48:58Z ESRI Edit Service does not honour milliseconds https://community.esri.com/t5/implementing-arcgis-questions/esri-edit-service-does-not-honour-milliseconds/m-p/356081#M329 <HTML><HEAD></HEAD><BODY><P>Using ESRI 10.5.1 Enterprise geodatabase SQL Server 2016</P><P>I have a layer with a field'START_STAMP' defined as datetime2(7)</P><P>Using an ESRI Edit Service I insert a row specifying an attribute as</P><P><SPAN style="color: #1f497d; font-size: 11pt;">"START_STAMP": 1543479941234</SPAN></P><P>I then use the same EDIT Service to retrieve the row and the attribute shows as</P><P><SPAN style="color: #1f497d; font-size: 11pt;">"START_STAMP": 1543479941000</SPAN></P><P></P><P>IE the timestamp has been truncated to the nearest second.</P><P></P><P>This is not the behavior I wanted (or expected)</P><P></P><P>Is there any way that I can avoid the truncation, or do I have to live in a world where a second is as close as I can get to the time?</P></BODY></HTML> Mon, 10 Dec 2018 05:48:58 GMT https://community.esri.com/t5/implementing-arcgis-questions/esri-edit-service-does-not-honour-milliseconds/m-p/356081#M329 JohnCuthbertson1 2018-12-10T05:48:58Z