Important: We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text.
To find a feature or item, use the Quick search bar.
For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight
Supported date formats
Amazon QuickSight supports the date and time formats described in this section. Before you add data to Amazon QuickSight, check if your date format is compatible. If you need to use an unsupported format, see Using unsupported or custom dates.
The supported formats vary depending on the data source type, as follows:
Data source | Clocks | Date formats |
---|---|---|
File uploads Amazon S3 sources Athena Salesforce |
Both 24-hour and 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 For
datasets stored in memory (SPICE), Amazon QuickSight supports dates in the
following range: |
Relational databases sources |
24-hour clock only |
The following data and time formats:
|