3 Replies Latest reply on Sep 8, 2013 11:44 AM by satrap

    OGG Using Colmap and Datenow millisecond.....

    ehyojiny

      Hi

       

      i have a problem.

       

      i want to put the current time in target table column.

       

      table column datatype

      SQL> desc yyy

      Name                                      Null?    Type

      ----------------------------------------- -------- ----------------------------

      COL1                                               VARCHAR2(30)

      COL2                                               VARCHAR2(30)

      COL3                                               TIMESTAMP(6)

       

       

      so i used the following parameter,

       

      1)

      MAP "GGS"."XXX"       ,      TARGET GGT.yyy      , colmap(col1=cola,col2=colb, col3=@date("yyyy-mm-dd hh:mi:ss.ss", "yyyy-mm-dd hh:mi:ss.ss", @datenow() );

      2)

      MAP "GGS"."XXX"       ,      TARGET GGT.yyy      , colmap(col1=cola,col2=colb, col3=@datenow() );

       

      the result of both two methods are as follows:

      3          4          02-SEP-13 01.55.00.000000

      4          5          02-SEP-13 01.56.53.000000

       

      @datenow function does not get the millisecond value?

       

      If I would like to express the value in milliseconds, what should i do?