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
epochDate
epochDate converts an epoch date into a standard date in the format
yyyy-MM-ddTkk:mm:ss.SSSZ, using the format
pattern syntax specified in Class DateTimeFormat2015-10-15T19:11:51.003Z.
epochDate is supported for use with analyses based on datasets
stored in QuickSight (SPICE).
Syntax
epochDate(epochdate)
Arguments
- epochdate
-
An epoch date, which is an integer representation of a date as the number of seconds since 00:00:00 UTC on January 1, 1970.
epochdate must be an integer. It can be the name of a field that uses the integer data type, a literal integer value, or a call to another function that outputs an integer. If the integer value is longer than 10 digits, the digits after the 10th place are discarded.
Return type
Date
Example
The following example converts an epoch date to a standard date.
epochDate(3100768000)
The following value is returned.
2068-04-04T12:26:40.000Z
