/    /  Amazon QuickSight – Date Formats

Amazon QuickSight – Date Formats

 

Amazon QuickSight is a cloud-based business intelligence tool that allows users to create interactive dashboards and visualizations from various data sources. QuickSight supports a wide range of data sources, including file uploads, Amazon S3 sources, Athena, Salesforce, and relational databases.

 

When using QuickSight with date data from file uploads, Amazon S3 sources, Athena, Salesforce, and relational databases, users can specify the date format for date fields to ensure that the data is parsed correctly. QuickSight supports various date formats, such as yyyy-MM-dd, MM/dd/yyyy, dd-MMM-yy, and more.

 

By specifying the correct date format, QuickSight can accurately interpret and use the date values for data analysis and visualization. This ensures that the resulting dashboards and reports provide accurate and meaningful insights to the users.

 

Following is a list of the formats supported by the various types of data sources:

Data sourceClocksDate formats
File uploads

Amazon S3 sources

Athena

Salesforce

24-hour & 12-hour clocks
  • Supported date and time formats are described in the Joda API documentation.
  • For a complete list of Joda date formats, see Class DateTimeFormat on the Joda website.
  • For datasets stored in memory (SPICE), Amazon QuickSight supports dates in the following range: Jan 1, 1400 00:00:00 UTC through Dec 31, 9999, 23:59:59 UTC.
Relational databases sources24-hour clock onlyThe following data and time formats:

  • dd/MM/yyyy HH:mm:ss, for example 31/12/2016 15:30:00.
  • dd/MM/yyyy, for example 31/12/2016.
  • dd/MMM/yyyy HH:mm:ss, for example 31/DEC/2016 15:30:00.
  • dd/MMM/yyyy, for example 31/DEC/2016.
  • dd-MMM-yyyy HH:mm:ss, for example 31-DEC-2016 15:30:00.
  • dd-MMM-yyyy, for example 31-DEC-2016.
  • dd-MM-yyyy HH:mm:ss, for example 31-12-2016 15:30:00.
  • dd-MM-yyyy, for example 31-12-2016.
  • MM/dd/yyyy HH:mm:ss, for example 12/31/2016 15:30:00.
  • MM/dd/yyyy, for example 12/31/2016.
  • MM-dd-yyyy HH:mm:ss, for example 12-31-2016 15:30:00.
  • MM-dd-yyyy, for example 12-31-2016.
  • MMM/dd/yyyy HH:mm:ss, for example DEC/31/2016 15:30:00.
  • MMM/dd/yyyy, for example DEC/31/2016.
  • MMM-dd-yyyy HH:mm:ss, for example DEC-31-2016 15:30:00.
  • MMM-dd-yyyy, for example DEC-31-2016.
  • yyyy/MM/dd HH:mm:ss, for example 2016/12/31 15:30:00.
  • yyyy/MM/dd, for example 2016/12/31.
  • yyyy/MMM/dd HH:mm:ss, for example 2016/DEC/31 15:30:00.
  • yyyy/MMM/dd, for example 2016/DEC/31.
  • yyyy-MM-dd HH:mm:ss, for example 2016-12-31 15:30:00.
  • yyyy-MM-dd, for example 2016-12-31.
  • yyyy-MMM-dd HH:mm:ss, for example 2016-DEC-31 15:30:00.
  • yyyy-MMM-dd, for example 2016-DEC-31.
  • yyyyMMdd’T’HHmmss, for example 20161231T153000.
  • yyyy-MM-dd’T’HH:mm:ss, for example 2016-12-31T15:30:00.
  • yyyyMMdd’T’HHmmss.SSS, for example 20161231T153000.123.
  • MM/dd/yyyy HH:mm:ss.SSS, for example 12/31/2016 15:30:00.123.
  • dd/MM/yyyy HH:mm:ss.SSS, for example 31/12/2016 15:30:00.123.
  • yyyy/MM/dd HH:mm:ss.SSS, for example 2016/12/31 15:30:00.123.
  • MMM/dd/yyyy HH:mm:ss.SSS, for example DEC/31/2016 15:30:00.123.
  • dd/MMM/yyyy HH:mm:ss.SSS, for example 31/DEC/2016 15:30:00.123.
  • yyyy/MMM/dd HH:mm:ss.SSS, for example 2016/DEC/31 15:30:00.123.
  • yyyy-MM-dd’T’HH:mm:ss.SSS, for example 2016-12-31T15:30:00.123.
  • MM-dd-yyyy HH:mm:ss.SSS, for example 12-31-2016 15:30:00.123.
  • dd-MM-yyyy HH:mm:ss.SSS, for example 31-12-2016 15:30:00.123.
  • yyyy-MM-dd HH:mm:ss.SSS, for example 2016-12-31 15:30:00.123.
  • MMM-dd-yyyy HH:mm:ss.SSS, for example DEC-31-2016 15:30:00.123.
  • dd-MMM-yyyy HH:mm:ss.SSS, for example 31-DEC-2016 15:30:00.123.
  • yyyy-MMM-dd HH:mm:ss.SSS, for example 2016-DEC-31 15:30:00.123.