15.4.1 Acceptable Formats for Timestamp Values

This sections lists the acceptable formats for timestamp values in Oracle Stream Analytics.

Format Example Values

MM/dd/yyyy HH:mm:ss.SSSS

3/21/2018 11:14:23.1111

MM/dd/yyyy HH:mm:ss.SSS

3/21/2018 11:14:23.111

MM/dd/yyyy HH:mm:ss.SS

3/21/2018 11:14:23.11

MM/dd/yyyy HH:mm:ss.S

3/21/2018 11:14:23.1

MM/dd/yyyy HH:mm:ss

3/21/2018 11:14:23

MM/dd/yyyy HH:mm

3/21/2018 11:14

MM/dd/yyyy HH

3/21/2018 11

MM/dd/yyyy

3/21/2018

MM-dd-yyyy HH:mm:ss.SSSS

11-21-2018 11:14:23.1111

MM-dd-yyyy HH:mm:ss.SSS

11-21-2018 11:14:23.111

MM-dd-yyyy HH:mm:ss.SS

11-21-2018 11:14:23.11

MM-dd-yyyy HH:mm:ss.S

11-21-2018 11:14:23.1

MM-dd-yyyy HH:mm:ss

11-21-2018 11:14:23

MM-dd-yyyy HH:mm

11-21-2018 11:14

MM-dd-yyyy HH

11-21-2018 11

MM-dd-yyyy

11-21-2018

dd-MMM-yy hh.mm.ss.SSSSSS a

11-Jan-18 11.14.23.111111 AM

dd-MMM-yy hh.mm.ss.SSSS

11-Jan-18 11.14.23.1111

dd-MMM-yy hh.mm.ss.SSS

11-Jan-18 11.14.23.111

dd-MMM-yy hh.mm.ss.SS

11-Jan-18 11.14.23.11

dd-MMM-yy hh.mm.ss.S

11-Jan-18 11.14.23.1

dd-MMM-yy hh.mm.ss

11-Jan-18 11.14.23

dd-MMM-yy hh.mm

11-Jan-18 11.14

dd-MMM-yy hh

11-Jan-18 11

dd-MMM-yy

11-Jan-18

dd/MMM/yy

15/MAR/18

yyyy-MM-dd HH:mm:ss.SSSSSS

2018-03-5 15:16:0.756000 +5:30,   2018-03-5 15:16:0.756000

yyyy-MM-dd HH.mm:.ss.SSSSSS

2018-03-5 15.16.0.756000 +5:30,   2018-03-5 15.16.0.756000

yyyy-MM-dd HH:mm:ss

2018-03-5 15:16:0;   2018-03-5 15:16:0 +5:30

yyyy-MM-dd HH.mm.ss

2018-03-5 15.16.0;   2018-03-5 15.16.0 +5:30

yyyy-MM-dd HH:mm

2018-03-5 15:16;   2018-03-5 15:16 +5:30

yyyy-MM-dd HH.mm

2018-03-5 15.16;   2018-03-5 15.16 +5:30

yyyy-MM-dd HH

2018-03-5 15

yyyy-MM-dd

2018-03-5

HH:mm:ss

11:14:14 PST

yyyy-MM-dd'T'HH:mm:ss'.'SSS

2018-03-04T12:08:56.235

yyyy-MM-dd'T'HH:mm:ss'.'SSSZ

2018-03-04T12:08:56.235-0700

yyyy-MM-dd'T'HH:mm:ss'.'SSSz

2018-03-04T12:08:56.235 PDT

yyyy-MM-dd'T'HH:mm:ss

2018-03-04T12:08:56

yyyy-MM-dd'T'HH:mm:ssZ

2018-03-04T12:08:56-0700

yyyy-MM-dd'T'HH:mm:ssz

2018-03-04T12:08:56 PDT