Re: Kudu time difference

Posted by Roshan on Nov 19, 2020; 7:46am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Kudu-time-difference-tp8856p9023.html

Hi Erman,

there is a date function in Striim which adds hours to a timestamp field.

https://www.striim.com/docs/en/date-functions.html

I have tried to use in COLUMNMAP  (DADD(ts, DHOURS(4)) but this format is not acceptable.

Incorrect column mapping is specified in {TRANS_DATE_D=DADD(TRANS_DATE_D, DHOURS(4)),CHRG_FROM_DATE_D=DADD(CHRG_FROM_DATE_D, DHOURS(4)),CHRG_TILL_DATE_D=DADD(CHRG_TILL_DATE_D, DHOURS(4)),DUE_DATE_D=DADD(DUE_DATE_D, DHOURS(4)),INVOICE_GENERATED_ON_D=DADD(INVOICE_GENERATED_ON_D, DHOURS(4)),DELIVERED_ON_D=DADD(DELIVERED_ON_D, DHOURS(4)),EMISSION_DATE_D=DADD(EMISSION_DATE_D, DHOURS(4))}