Supported date formats - 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 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 sources

24-hour clock only

The following data and time formats:

  1. dd/MM/yyyy HH:mm:ss, for example 31/12/2016 15:30:00.

  2. dd/MM/yyyy, for example 31/12/2016.

  3. dd/MMM/yyyy HH:mm:ss, for example 31/DEC/2016 15:30:00.

  4. dd/MMM/yyyy, for example 31/DEC/2016.

  5. dd-MMM-yyyy HH:mm:ss, for example 31-DEC-2016 15:30:00.

  6. dd-MMM-yyyy, for example 31-DEC-2016.

  7. dd-MM-yyyy HH:mm:ss, for example 31-12-2016 15:30:00.

  8. dd-MM-yyyy, for example 31-12-2016.

  9. MM/dd/yyyy HH:mm:ss, for example 12/31/2016 15:30:00.

  10. MM/dd/yyyy, for example 12/31/2016.

  11. MM-dd-yyyy HH:mm:ss, for example 12-31-2016 15:30:00.

  12. MM-dd-yyyy, for example 12-31-2016.

  13. MMM/dd/yyyy HH:mm:ss, for example DEC/31/2016 15:30:00.

  14. MMM/dd/yyyy, for example DEC/31/2016.

  15. MMM-dd-yyyy HH:mm:ss, for example DEC-31-2016 15:30:00.

  16. MMM-dd-yyyy, for example DEC-31-2016.

  17. yyyy/MM/dd HH:mm:ss, for example 2016/12/31 15:30:00.

  18. yyyy/MM/dd, for example 2016/12/31.

  19. yyyy/MMM/dd HH:mm:ss, for example 2016/DEC/31 15:30:00.

  20. yyyy/MMM/dd, for example 2016/DEC/31.

  21. yyyy-MM-dd HH:mm:ss, for example 2016-12-31 15:30:00.

  22. yyyy-MM-dd, for example 2016-12-31.

  23. yyyy-MMM-dd HH:mm:ss, for example 2016-DEC-31 15:30:00.

  24. yyyy-MMM-dd, for example 2016-DEC-31.

  25. yyyyMMdd'T'HHmmss, for example 20161231T153000.

  26. yyyy-MM-dd'T'HH:mm:ss, for example 2016-12-31T15:30:00.

  27. yyyyMMdd'T'HHmmss.SSS, for example 20161231T153000.123.

  28. MM/dd/yyyy HH:mm:ss.SSS, for example 12/31/2016 15:30:00.123.

  29. dd/MM/yyyy HH:mm:ss.SSS, for example 31/12/2016 15:30:00.123.

  30. yyyy/MM/dd HH:mm:ss.SSS, for example 2016/12/31 15:30:00.123.

  31. MMM/dd/yyyy HH:mm:ss.SSS, for example DEC/31/2016 15:30:00.123.

  32. dd/MMM/yyyy HH:mm:ss.SSS, for example 31/DEC/2016 15:30:00.123.

  33. yyyy/MMM/dd HH:mm:ss.SSS, for example 2016/DEC/31 15:30:00.123.

  34. yyyy-MM-dd'T'HH:mm:ss.SSS, for example 2016-12-31T15:30:00.123.

  35. MM-dd-yyyy HH:mm:ss.SSS, for example 12-31-2016 15:30:00.123.

  36. dd-MM-yyyy HH:mm:ss.SSS, for example 31-12-2016 15:30:00.123.

  37. yyyy-MM-dd HH:mm:ss.SSS, for example 2016-12-31 15:30:00.123.

  38. MMM-dd-yyyy HH:mm:ss.SSS, for example DEC-31-2016 15:30:00.123.

  39. dd-MMM-yyyy HH:mm:ss.SSS, for example 31-DEC-2016 15:30:00.123.

  40. yyyy-MMM-dd HH:mm:ss.SSS, for example 2016-DEC-31 15:30:00.123.