Supported Time and Date Formats

Metric Insights supports various types of Date formats. If a column of uploaded data contains dates in one of these formats, the system recognizes it and can perform different aggregations based on year, month, quarter, etc.

Format Example
'%Y-%m-%d %H:%M:%S' ( or '%Y-%m-%d %H:%M') 2017-03-27 15:25:31 (2017-03-27 15:25)
'%Y/%m/%d %H:%M:%S' (or '%Y/%m/%d %H:%M') 2017/03/27 15:25:31 (2017/03/27 15:25)
'%Y.%m.%d %H:%M:%S' (or '%Y.%m.%d %H:%M') 2017.03.27 15:25:31 (2017.03.27 15:25)
'%m/%d/%Y %H:%M:%S' (or '%m/%d/%Y %H:%M') 03/27/2017 15:25:31 (03/27/2017 15:25)
'%m/%d/%y %H:%M:%S' (or '%m/%d/%y %H:%M') 03/27/17 15:25:31 (03/27/17 15:25)
'%Y-%B-%d %H:%M:%S' (or '%Y-%B-%d %H:%M') 2017-March-27 15:25:31 (2017/03/27 15:25)
'%m/%d/%Y %I:%M:%S %p' (or '%m/%d/%Y %I:%M %p') 03/27/2017 3:25:31 PM (03/27/2017 3:25 PM)
'%B %d, %Y %I:%M %p' March 27, 2017 3:25 PM
'%B %d, %Y %I %p' March 27, 2017 3 PM
'%a %b %d %H:%M:%S %Z %Y' Mon Mar 27 15:25:31 EST 2017
'%Y-%m-%d' 2017-03-27
'%Y/%m/%d' 2017/03/27
'%Y.%m.%d' 2017.03.27
'%Y-%b-%d' 2017-Mar-27
'%m-%d-%Y' 03-27-2017
'%m-%d-%y' 03-27-17
'%m/%d/%Y' 03/27/2017
'%m/%d/%y' 03/27/17
'%d %b %Y' 27 Mar 2017
'%d-%b-%y' 27-Mar-17
'%B %d %Y' March 27 2017
'%B %d,%Y' March 27, 2017
'%Y-%m' 2017-03
'%b, %Y' Mar, 2017
'%b,%Y' Mar,2017
'%b %Y' Mar 2017
'%B, %Y' March, 2017
'%B,%Y' March,2017
'%B %Y' March 2017

0 Comments

Add your comment

E-Mail me when someone replies to this comment