Skip to main content
  • EN

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.

I received Fme_rejection_code as "Invalid_input". Please help. Thanks.

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)

 

nielsgerrits,

Thanks for your suggestions and it works perfectly. It is exactly the problem you suggested. I resolved the issue using your suggestion.

Reply


Community Stats

30,168
Posts
114,526
Replies
37,824
Members
Terms & ConditionsCookie settings
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.