AnsweredAssumed Answered

Converting UTC Date to String

Question asked by YR_Police on Nov 15, 2017
Latest reply on Nov 15, 2017 by YR_Police

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 1510309631000

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. 

Eg 1510309631000 this datetime converts to Friday, November 10, 2017 10:27:11 AM using an online converter and is the correct date and time.

Through GeoEvent my output is Fri Nov 10 05:27:11 EST 2017

 

Any way to get these to match?

 

Thanks

Outcomes