My Oracle Support Banner

Compute Function In COLMAP Not Giving Expected Result (Doc ID 2337085.1)

Last updated on SEPTEMBER 17, 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'.




To view full details, 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 a vibrant support community of peers and Oracle experts.