3 Replies Latest reply: Sep 8, 2013 6:44 AM by satrap RSS

    OGG Using Colmap and Datenow millisecond.....




      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,



      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() );


      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

      4          5          02-SEP-13


      @datenow function does not get the millisecond value?


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