Skip to main content
  • EN

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?

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.
@LenaAtSafe @taiatsafe I don't know whether either of you have looked at filetime?

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/

Reply


Community Stats

30,185
Posts
114,571
Replies
37,848
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.