topic Converting UTC Date to String in ArcGIS GeoEvent Server Questions https://community.esri.com/t5/arcgis-geoevent-server-questions/converting-utc-date-to-string/m-p/672375#M2982 <HTML><HEAD></HEAD><BODY><P>I have a date field that is a datetime2 field coming from a SQL database. When I ingest through GeoEvent it was being displayed as an Epoch date, eg&nbsp;1510309631000</P><P>I create a new field using my date field as a string and use that string to display in my final output. However the date displayed is 5 hours previous to the actual occurred time.&nbsp;</P><P>Eg&nbsp;<SPAN>1510309631000&nbsp;</SPAN>this datetime converts to&nbsp;<SPAN style="color: #000000; background-color: #ffffff;">Friday, November 10, 2017 10:27:11 AM using an online converter and is the correct date and time. </SPAN></P><P><SPAN style="color: #000000; background-color: #ffffff;">Through GeoEvent my output is&nbsp;Fri Nov 10 05:27:11 EST 2017</SPAN></P><P></P><P><SPAN style="color: #000000; background-color: #ffffff;">Any way to get these to match?</SPAN></P><P></P><P><SPAN style="color: #000000; background-color: #ffffff;">Thanks</SPAN></P></BODY></HTML> Wed, 15 Nov 2017 13:54:20 GMT StephaniePiper1 2017-11-15T13:54:20Z Converting UTC Date to String https://community.esri.com/t5/arcgis-geoevent-server-questions/converting-utc-date-to-string/m-p/672375#M2982 <HTML><HEAD></HEAD><BODY><P>I have a date field that is a datetime2 field coming from a SQL database. When I ingest through GeoEvent it was being displayed as an Epoch date, eg&nbsp;1510309631000</P><P>I create a new field using my date field as a string and use that string to display in my final output. However the date displayed is 5 hours previous to the actual occurred time.&nbsp;</P><P>Eg&nbsp;<SPAN>1510309631000&nbsp;</SPAN>this datetime converts to&nbsp;<SPAN style="color: #000000; background-color: #ffffff;">Friday, November 10, 2017 10:27:11 AM using an online converter and is the correct date and time. </SPAN></P><P><SPAN style="color: #000000; background-color: #ffffff;">Through GeoEvent my output is&nbsp;Fri Nov 10 05:27:11 EST 2017</SPAN></P><P></P><P><SPAN style="color: #000000; background-color: #ffffff;">Any way to get these to match?</SPAN></P><P></P><P><SPAN style="color: #000000; background-color: #ffffff;">Thanks</SPAN></P></BODY></HTML> Wed, 15 Nov 2017 13:54:20 GMT https://community.esri.com/t5/arcgis-geoevent-server-questions/converting-utc-date-to-string/m-p/672375#M2982 StephaniePiper1 2017-11-15T13:54:20Z Re: Converting UTC Date to String https://community.esri.com/t5/arcgis-geoevent-server-questions/converting-utc-date-to-string/m-p/672376#M2983 <HTML><HEAD></HEAD><BODY><P>I sorted it out, added an additional processor prior to this one to add 18000000 to my original field. Set that to a new field and then set that field to my string.&nbsp;</P></BODY></HTML> Wed, 15 Nov 2017 15:04:00 GMT https://community.esri.com/t5/arcgis-geoevent-server-questions/converting-utc-date-to-string/m-p/672376#M2983 StephaniePiper1 2017-11-15T15:04:00Z