Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Changing ODI Date Variable Format

dilekFeb 3 2014 — edited Feb 6 2014

Hello Everyone,

I am using a date variable in ODI. I gave the value of 'select add_months(sysdate, -3) from dual', however there is a problem with its generated value. ODI generates the value as;

2013-11-03 09:21:09.0

When the parameter comes to execution time, it gives an error like 'Missing parameter :21:09.0', because Oracle expects a variable when it sees ':' sign. Therefore, I need to change the date format in ODI. I tried to give value as;

add_months(trunc(sysdate), -3)

but nothing changed. It only change hour, min value to 0. ':' still exists.

Can you help me please?

Thank You

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 6 2014
Added on Feb 3 2014
#business-intelligence-applications, #data-integrator, #system-management-and-integration
11 comments
6,522 views