Menu
Amazon QuickSight
User Guide

epochDate Function

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), for example 2015-10-15T19:11:51.003Z.

Syntax

Copy
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. Note that 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.

Copy
epochDate(3100768000)

The following value is returned:

Copy
2068-04-04T12:26:40.000Z