topic ArcGIS Featureservice layer and Dates in ArcGIS REST APIs and Services Questions https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/arcgis-featureservice-layer-and-dates/m-p/516654#M2463 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to add data to ArcSDE (10.01 installed on MS SQL 2008R2) using arcgis server feature service layer. I am not using ESRI's APIs. I tried to add dates but its not working...Date in sql is of field type "datetime2(7)" which i can not change to other fields.. It only take numbers like "03102012" but in database it changes to a strange date....</SPAN><BR /><BR /><SPAN>any help in this regard...</SPAN></BODY></HTML> Wed, 05 Oct 2011 23:43:16 GMT ZahidChaudhry 2011-10-05T23:43:16Z ArcGIS Featureservice layer and Dates https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/arcgis-featureservice-layer-and-dates/m-p/516654#M2463 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to add data to ArcSDE (10.01 installed on MS SQL 2008R2) using arcgis server feature service layer. I am not using ESRI's APIs. I tried to add dates but its not working...Date in sql is of field type "datetime2(7)" which i can not change to other fields.. It only take numbers like "03102012" but in database it changes to a strange date....</SPAN><BR /><BR /><SPAN>any help in this regard...</SPAN></BODY></HTML> Wed, 05 Oct 2011 23:43:16 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/arcgis-featureservice-layer-and-dates/m-p/516654#M2463 ZahidChaudhry 2011-10-05T23:43:16Z Re: ArcGIS Featureservice layer and Dates https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/arcgis-featureservice-layer-and-dates/m-p/516655#M2464 <HTML><HEAD></HEAD><BODY><SPAN>I believe this field type requires a timestamp similar to the unix timestamp. So 03102012 would be a very early date. 03102012 = 2/5/1970 9:40:12 PM UTC. So 10/10/2011 12:00:00 AM UTC would be: 1318204800.</SPAN><BR /><BR /><SPAN>Read Here:</SPAN><BR /><A href="http://help.arcgis.com/en/arcgisserver/10.0/apis/rest/feature.html">http://help.arcgis.com/en/arcgisserver/10.0/apis/rest/feature.html</A><BR /><BR /><BLOCKQUOTE class="jive-quote">"Note that date values are encoded as numbers. The number represents the number of milliseconds since epoch (January 1, 1970) in UTC." </BLOCKQUOTE><BR /><BR /><SPAN>Which Unix timestamp is the number of seconds since epoch. Seems you can use the Unix timestamp if you only need to the second accuracy.</SPAN><BR /><BR /><SPAN>What programming language are you using?</SPAN></BODY></HTML> Mon, 10 Oct 2011 13:04:42 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/arcgis-featureservice-layer-and-dates/m-p/516655#M2464 RobChouinard 2011-10-10T13:04:42Z