Skip to main content
  • EN

Does anyone have suggestion/workaround for inserting data into Oracle "Interval" data type field?

 

I don't see any comments on FME idea. But I thought it worth asking in forum if someone had a workaround.

 

https://community.safe.com/s/idea/0874Q000000TlVCQA0/detail?smartspace=ideas-fme-server&t=1616021806783

 

 

My only thought is building a trigger on table. Use a varchar2 field and convert it into "interval" type before insert or updates. 

@ssmith_ftr​ I think that is your only workaround. But, I think, FME won't be able to read back that interval data type either.

Don't forget to vote for that Idea!

Reply


Community Stats

30,179
Posts
114,561
Replies
37,844
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.