What is the value of @GETENV ('JULIANTIMESTAMP')? (Doc ID 2225419.1)

Last updated on JANUARY 20, 2017

Applies to:

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

Goal

OS > date
Thu Jan 19 14:44:55 PST 2017

using NUM = @GETENV ('JULIANTIMESTAMP') to populate a target column value returns:

TO_CHAR(NUM,'000000
-------------------
 212351625816711662

But it should be about 2457773 days after julian day.

What is above value (212351625816711662)?
 

Solution

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