Converting UTC Date to String

655
1
11-15-2017 05:54 AM
StephaniePiper1
New Contributor

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

0 Kudos
1 Reply
StephaniePiper1
New Contributor

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. 

0 Kudos