topic Re: tOracleOutput - Insert oracle SYSDATE in Talend Studio

tOracleOutput - Insert oracle SYSDATE

santhosh_saraf — Thu, 02 Mar 2017 11:43:35 GMT

Hi,
How to insert current date in table with oracle "SYSDATE" as expression rather than Talend current date ( such as "TalendDate.getCurrentDate()"). The reason for choosing SYSDATE is due to the difference between TAC and database time zones.
This is my scenario:
I need to alert notifications based on the exceptions occured during a perticular period.
tLogCatcher -->tOracleOutput
Thanks

Re: tOracleOutput - Insert oracle SYSDATE

TRF — Thu, 02 Mar 2017 14:14:01 GMT

Hi,
You can define a default value on Oracle side or convert date from one timezone to an other (using Java) or use tOracleRow in place of tOracleOutput.
Regards,
TRF

Re: tOracleOutput - Insert oracle SYSDATE

santhosh_saraf — Thu, 16 Mar 2017 14:11:37 GMT

Thanks
Used tOracleRow and resolved my issue.