2 Replies Latest reply on Jun 17, 2019 4:54 AM by Nico Heinze

    Populate Timestamp value in Oracle

    Kamal Haria Active Member

      Hi

       

      I want to set a default date value of 31-MAR-99 12.00.00.000000000 AM (Year is 9999) for a column in Oracle table for all records while running my mapping I have a mapping in Informatica Powercenter. In expression transformation, I need to set this value so that the required date is populated in Oracle table. In Informatica you can set the type date/time and in Oracle it is TIMESTAMP(6)

       

      It is giving error when try to use To_char or to_date functionality

       

      Please advise.

       

      Regards

       

      Kamal