1. GoldenGate Stream Analytics
  2. Manage
  3. Streams
  4. Manage Streams
  5. Supported Timestamp Formats in an Input Stream

Supported Timestamp Formats in an Input Stream

The following timestamp formats, in an input stream, are supported:
  • 11/21/2005 11:14:23.111 "MM/dd/yyyy HH:mm:ss.SSS"
  • 11/21/2005 11:14:23.11 "MM/dd/yyyy HH:mm:ss.SS"
  • 11/21/2005 11:14:23.1 "MM/dd/yyyy HH:mm:ss.S"
  • 11/21/2005 11:14:23 "MM/dd/yyyy HH:mm:ss"
  • 11/21/2005 11:14 "MM/dd/yyyy HH:mm"
  • 11/21/2005 11:14 "MM/dd/yyyy HH"
  • 11/21/2005 "MM/dd/yyyy"
  • 11-21-2005 11:14:23.111 "MM-dd-yyyy HH:mm:ss.SSS"
  • 11-21-2005 11:14:23.11 "MM-dd-yyyy HH:mm:ss.SS"
  • 11-21-2005 11:14:23.1 "MM-dd-yyyy HH:mm:ss.S"
  • 11-21-2005 11:14:23 "MM-dd-yyyy HH:mm:ss"
  • 11-21-2005 11:14 "MM-dd-yyyy HH:mm"
  • 11-21-2005 11 "MM-dd-yyyy HH"
  • 11-21-2005 "MM-dd-yyyy"
  • 15-DEC-01 11.14.14.111 AM"dd-MMM-yy hh.mm.ss.SSS"
  • 15-DEC-01 11.14.14.11 "dd-MMM-yy hh.mm.ss.SS"
  • 15-DEC-01 11.14.14.1 "dd-MMM-yy hh.mm.ss.S"
  • 15-DEC-01 11.14.14 "dd-MMM-yy hh.mm.ss"
  • 15-DEC-01 11.14 "dd-MMM-yy hh.mm"
  • 15-DEC-01 11 "dd-MMM-yy hh"
  • 15-DEC-01 "dd-MMM-yy"
  • 15/DEC/01 "dd/MMM/yy"
  • 2013-10-5 15:16:0.756 "yyyy-MM-dd HH:mm:ss.SSS"
  • 2013-10-5 15.16.0.756 "yyyy-MM-dd HH.mm.ss.SSS"
  • 2013-10-5 15:16:0 "yyyy-MM-dd HH:mm:ss"
  • 2013-10-5 15.16.0 "yyyy-MM-dd HH.mm.ss"
  • 2013-10-5 15:16 "yyyy-MM-dd HH:mm"
  • 2013-10-5 15.16 "yyyy-MM-dd HH.mm"
  • 2013-10-5 15 "yyyy-MM-dd HH"
  • 2012-11-10 "yyyy-MM-dd"
  • 11:14:14 "HH:mm:ss"
  • "yyyy-MM-dd'T'HH:mm:ss'.'SSS"
  • "yyyy-MM-dd'T'HH:mm:ss"
  • 1/1/2011 "m/d/yyyy"
  • 1-1-2011 "m-d-yyyy"
  • 3/23/2019 "m/dd/yyyy"
  • 3-23-2019 "m-dd-yyyy"
  • 12/4/1982 "mm/d/yyyy"
  • 12-4-2019 "mm-d-yyyy"

Note:

The input timestamp is truncated to millisecond precision.