Sample Header Ad - 728x90

Goldengate timestamp (FFF)

0 votes
1 answer
1012 views
Working with Goldengate 19.1.0.0.211019 replicat inbound to Oracle 19.0.0.0.0 consuming a trail file incoming from Nonstop (ie a non-Oracle database). Column in question from Nonstop is a string containing value of: "20210723112304812" in format of: "yyyymmddhhmmssfff" ie timestamp. In my replicat, I use following colmap in the appropriate map .. target command: COLMAP ( usedefaults, TS_UPDATE = @DATE ( 'YYYY-MM-DD HH:MI:SS.FFF', 'YYYYMMDDHHMMSSFFF', TS_UPDATE ) ); Howevever, finishing, the data stored in Oracle is: (defined as TIMESTAMP(3) ) 23-jul-2021 11:23:04.001 and other dates either get a ".001" or ".000" value for the fractional second everytime. I have also tried: @DATE ( 'YYYY-MM-DD HH:MI:SS.FFFFFF', 'YYYYMMDDHHMMSSFFFFFF', TS_UPDATE ) with same results. What format setting should I be using to import/include the fractional second properly from non_oracle DB into Oracle DB with TIMESTAMP(3) ??
Asked by Ditto (504 rep)
Jan 19, 2022, 03:32 PM
Last activity: Jun 5, 2025, 03:03 PM