tOracleOutput - Insert oracle SYSDATE

[santhosh_saraf]

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

[TRF]

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

[santhosh_saraf]

Thanks
Used tOracleRow and resolved my issue.