Skip to main content
Question

Insert (writer) data into Oracle "Interval" data type field?

  • March 17, 2021
  • 1 reply
  • 30 views

ssmith_ftr
Contributor
Forum|alt.badge.img+6

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. 

1 reply

Forum|alt.badge.img+2

@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


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