I have GeoJason data from USGS site which contains Epoch time such as 1650016756409 or 1649948565590. I tried to read them in either %s$ or %Es% using DateTimeConverter, all failed and cannot convert. I am using FME desktop 2021.2. Please help.
Solved
Cannot convert Epoch time to human datetime
+4- Contributor
Best answer by nielsgerrits
According to the documentation %s or %Es are expected to be in seconds. When checking your datetimestamps with an epoch converter on the internet, they appear to be in milliseconds. I know this because I have had the same problem :)
You can convert from milliseconds to seconds using the ExpressionEvaluator or an AttributeCreator using
@Evaluate(@Value(datetime_epoch_miliseconds)/1000)
+54- Best Answer
According to the documentation %s or %Es are expected to be in seconds. When checking your datetimestamps with an epoch converter on the internet, they appear to be in milliseconds. I know this because I have had the same problem :)
You can convert from milliseconds to seconds using the ExpressionEvaluator or an AttributeCreator using
@Evaluate(@Value(datetime_epoch_miliseconds)/1000)
+4- Contributor
nielsgerrits,
Thanks for your suggestions and it works perfectly. It is exactly the problem you suggested. I resolved the issue using your suggestion.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.