Formatting the resulting interval (ISO Duration)

PT28M20S is a duration of 28 minutes and 20 seconds, it can't be converted to an FME datetime. Or do you mean you want to add it onto a known date time?

Hi @ebygomm,

No I want to format it into a FME datetime, so that I can eventually write it out as a datetime.

So I guess it's gonna be 'the hard way'....padding, etc

PT28M20S is a duration of 28 minutes and 20 seconds, it can't be converted to an FME datetime. Or do you mean you want to add it onto a known date time?

@itay Oracle and other databases do have Interval date types. This isn't something we have tackled in FME yet so you'll have to parse the FME Duration for now. Also, I don't think the FME feature types support the 'interval' data types so you'll have to create the table before you write to it.

Thx for the info @markatsafe, luckily the table already exists.

Hi @ebygomm,

No I want to format it into a FME datetime, so that I can eventually write it out as a datetime.

So I guess it's gonna be 'the hard way'....padding, etc

You could probably do some string manipulation, but there is also an easy to use python library isodate that will do it for you.

pip install isodate

import isodate 
duration = 'PT28M20S'
print(isodate.parse_duration(duration))

Result

0:28:20

If you're actually wanting to write to an interval date type column if you want to avoid parsing the date time interval you can create a dummy date which contains the interval added onto an arbitrary date

and write that into a temporary table. Then populate the interval column with a query by taking the arbitrary date away from the dummy date.

FME doesn't play nicely with columns of interval date types (unless this has changed in 2020) so that's something to be aware of. You cannot 'see' the interval columns with the reader, you can read with sqlcreator/sqlexecutor if you convert them (and know they're there and their names)