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!

How to get sysdate into an ODI variable?

Marco FrisApr 7 2021

Hi all,
I am probably overlooking something obvious, but I can't manage to do this. We want this variable for a simple incremental load setup into our datavault.
I tried the obvious, like:
<%=odiRef.getSysDate("YYYY-MM-DDThh:mm:ssZ")%>
<%=odiRef.getSysDate()%>
select to_char(sysdate, 'YYYY-MM-DD"T"HH24:MI:SS"+0100"') from dual;
... and a bunch of variations on that, but all I get back is 'Unparseable date'.
Any help appreciated.

This post has been answered by Rodrigo Radtke Souza on Apr 7 2021

Jump to Answer

Added on Apr 7 2021

#business-intelligence-applications, #data-integrator, #system-management-and-integration

2 comments

1,359 views