Skip to main content
Solved

Convert to/from FILETIME


sigtill
Supporter
Forum|alt.badge.img+24

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/

View original
Did this help you find an answer to your question?

3 replies

Forum|alt.badge.img+2

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.

Forum|alt.badge.img+2
@LenaAtSafe @taiatsafe I don't know whether either of you have looked at filetime?

david_r
Evangelist
  • Best Answer
  • July 13, 2017

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings