Supported Date Formats

Below is a list of Date Formats that are supported in Metric Insights.

Dates falling outside of the range [1900-01-01 00:00:00  ..  9999-01-01 00:00:00] will not be processed.

Date Format Example
yyyy 2019
yyyy-MM 2019-01
yyyy-MMM 2019-DEC
yyyy-MM-dd 2019-01-01
yyyy-MMM-dd 2019-FEB-01
yyyy-MMMMM-dd HH:mm:ss 2019-August-01 01:23:45
yyyy-MM-dd'T'HH:mm:ss 2019-03-10T01:34:26
yyyy-MM-dd'T'HH:mm:ss.SSS 2019-05-26T11:34:14.000
MMM, yyyy Jan, 2019
MMMMM, yyyy January, 2019
MM/dd/yy 01/01/19
MM-dd-yyyy 01-01-2019
MM/dd/yyyy HH 01/01/2019 01
MM/dd/yyyy HH:mm 01/01/2019 01:23
MM/dd/yyyy HH:mm:ss 01/01/2019 01:23:45
MMMMM d, yyyy h a April 15, 2019 1 AM
MMMMM d, yyyy h:mm a April 15, 2019 1:00 AM
M/d/yyyy h:m:s a 4/15/2019 1:00:00 AM
dd/mm/yy 21/01/19
dd/mm/yyyy 21/01/2019
dd.MM.yyyy 31.03.2019
dd MMM yyyy 05 Nov 2019
dd-MMM-yy 4-Jan-19
dd-MMM-yyyy 17-SEP-2019
EEE MMM dd HH:mm:ss z yyyy Wed Aug 21 15:50:21 UTC 2019

0 Comments

Add your comment

E-Mail me when someone replies to this comment