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
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.