Skip to main content
Solved

Converting ISODateTime to FME Date/Time

  • December 17, 2018
  • 1 reply
  • 43 views

fmeuser_gc
Contributor
Forum|alt.badge.img+8

I'm trying to convert ISO datetime to FME DateTime in 2015 version. Have tried using DateFormatter transformer but gives wrong output. It is strangely displaying Expected datetime+02:00 hrs. It looks like it may work in other versions, but not in 2015. Not sure what the issue is.

For ex: The value 2018-12-13T22:05:36.000Z (ISODateTime) gives 2018-12-14 00:05:36 instead of 2018-12-13 22:05:36

Any suggestions please? Thanks in advance.

Tagging @takashi, @david_r.

 

 

 

Best answer by takashi

There were several issues in the old DateFormatter. If you set the source date format explicitly, correct conversion could be done.

  • Source Date Format: %Y-%m-%dT%H:%M:%S
  • Destination Date Format: %Y-%m-%d %H:%M:%S

The date/time operations in FME were drastically upgraded in 2017. I would recommend you to upgrade FME version if date/time operations are critical in your projects.

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

takashi
Contributor
Forum|alt.badge.img+19
  • Contributor
  • December 17, 2018

There were several issues in the old DateFormatter. If you set the source date format explicitly, correct conversion could be done.

  • Source Date Format: %Y-%m-%dT%H:%M:%S
  • Destination Date Format: %Y-%m-%d %H:%M:%S

The date/time operations in FME were drastically upgraded in 2017. I would recommend you to upgrade FME version if date/time operations are critical in your projects.


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