span8
span4
span8
span4
我的读入g a Json file that contains a timestamp. I need to convert this to a date so that I can aggregate other data on Year, Month.
I've tried using an attributemananger (@value/86400)+25569+(-5/24) and DatConverter to convert the timestamp but this didn't gave me any results.
Therefore my question how to do this?
If it's the seconds since the Unix epoch you can use the DateTimeConvertor. Source format is%s, output format can be FME or ISO date, whichever you prefer.
This is an example of a timestamp. "lastUpdated":1502349196
But additional: In my attributemanager I am using the Arithmetic editor. This results in a number.
Do I have to do something to convert this back to a string? I thought I read something that FME automatically convert this when needed.
What is the format of the timestamp in your json? It would be helpful if you could post an example here.
© 2020 Safe Software Inc |Legal