Compute Function In COLMAP Not Giving Expected Result

(Doc ID 2337085.1)

Last updated on JANUARY 10, 2018

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


Trying to convert the date format from Julian to Gregorian in Oracle GoldenGate not giving the expected result for one particular date

1) goldendate @DATE:
CXEFT_test = @DATE('YYYY-MM-DD', 'YYYYDDD', @COMPUTE(CXEFT_test+ 1900000)),  -- Where CXEFT_test was coming from trail file as 116002
=> 1/1/2016

2)SQL>  select TO_DATE(TO_CHAR(116002+1900000) ,'YYYYDDD') from dual;
=> 1/2/2016

Date value ' 1/2/YYYY' converted into '1/1/YYYY'.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms