Compute Function In COLMAP Not Giving Expected Result
Last updated on JANUARY 10, 2018
Applies to:Oracle GoldenGate - Version 22.214.171.124.10 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
2)SQL> select TO_DATE(TO_CHAR(116002+1900000) ,'YYYYDDD') from dual;
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