Skip to main content
Question

Converting to Epoch Time?

  • August 13, 2024
  • 1 reply
  • 165 views
schulte.a
Contributor
Forum|alt.badge.img+3

I am having trouble getting this converted to the right format. The times seem way off when I use the date time converter. 

 

This was a time stamp that was in a response message to a REST call that I got. Would anyone know how to prep these values + set up the date time converter correctly?

“1722597785000” ← format of timestamp

 

Thank you!

danilo_fme

1 reply

debbiatsafe
Safer
Forum|alt.badge.img+21
  • debbiatsafeSafer
  • Safer
  • August 14, 2024

Hello @schulte.a,

The timestamp is milliseconds since Unix Epoch. The %s and %Es flags in the DateTimeConverter represent seconds since Unix Epoch.

Divide the timestamp by 1000 before converting the timestamp in the DateTimeConverter. Doing this will result in 2024-08-02T11:23:05 from the sample timestamp and %Es as the input format.

nielsgerrits
liamfez

Community Stats

32,184
Posts
122,184
Replies
39,856
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.