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

    Populate Timestamp value in Oracle

    Kamal Haria Active Member



      I want to set a default date value of 31-MAR-99 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.