Solved

Convert to/from FILETIME

Forum|Forum|8 years ago
July 12, 2017
3 replies
71 views

+25

sigtill
Supporter

I need to convert to/from FILETIME in FME2016.....

So for instance FILETIME=131443544400651329

http://www.silisoftware.com/tools/date.php?inputdate=131443544400651329&inputformat;=filetime

Will be converted to:

2017-07-12T17:34:00+00:00

Some hints here:

https://stackoverflow.com/questions/19801727/convert-datetime-to-unix-timestamp-and-convert-it-back-in-python

However I am curious if there is a simpler way to do this in FME?

Best answer by david_r

Looks like you could implement it fairly easily in Python as well:

http://reliablybroken.com/b/2009/09/working-with-active-directory-filetime-values-in-python/

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

J

+2

jlutherthomas
Forum|Forum|8 years ago
July 13, 2017

Hi @sigtill

So I could kind of do it in FME 2016 by calling the URL from the HTTPCaller. However, you then need to extract the right time format that you're interested in. So I'm not sure if that's simpler than python.

If you could use FME 2017, putting that URL in the HTML Table Reader was nicer.