Skip to content

GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Date conversion from DB2 timestamp to MS SQL character

edited June 2014 in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered

GoldenGate version 12.1.2.0.1 with DB2 on iSeries. In an initial load I have the following in the replicat to convert a DB2 timestamp column to a character column on the MS SQL 2008R2 database.

CDACHANGETIMESTAMP             =  @DATE('YYYY-MM-DD HH:MI:SS.FFFFFF', 'YYYY-MM-DD:HH:MI:SS.FFFFFF', CDA_CHANGE_TIME)

I am running into an issue with DB2 source values that have unexpected results.If the value on the DB2 side is 0001-01-01 00:00:00.000000 the results of using the @date function is 2001-01-01 00:00:00.000000. Any thoughts on how to get the results in the expected format?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center