1. Oracle GoldenGate for Distributed Applications and Analytics
  2. Administer
  3. Parsing the Message
  4. Delimited Parsing
  5. Parsing Properties
  6. Properties to Describe Date and Time

9.2.3.2.3 Properties to Describe Date and Time

The default format YYYY-DD-MM HH:MM:SS.FFF is used to parse dates. You can use properties to override this on a global, table or column level. Examples of changing the format are shown below. 

delim.dateformat.default=MM/DD/YYYY-HH:MM:SS
delim.dateformat.MY.TABLE=DD/MMM/YYYY
delim.dateformat.MY.TABLE.COL1=MMYYYY

Parent topic: Parsing Properties