+4
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.
Best answer by nielsgerrits
View original
+4
I received Fme_rejection_code as "Invalid_input". Please help. Thanks.
+32
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
nielsgerrits,
Thanks for your suggestions and it works perfectly. It is exactly the problem you suggested. I resolved the issue using your suggestion.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.