Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

epochDate

Focus mode
epochDate - Amazon QuickSight

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 DateTimeFormat in the Joda project documentation. An example is 2015-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
PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.