EXAMPLE - Unixtime Functions

Contents:

Expand all Collapse all

Scheduled Maintenance: docs.trifacta.com will be offline for maintenance at 3:00pm UTC on Tuesday March 28 for about 15 minutes.

This example illustrates how you can use functions to manipulate Unix time values in a column of Datetime type.

UNIXTIME - Returns the Unix time value computed from a Datetime value. See UNIXTIME Function.
UNIXTIMEFORMAT - Formats a Unix time value in the specified manner. See UNIXTIMEFORMAT Function.

Source:

Transformation:

Use the following transformation step to generate a column containing the above values as Unix timecode values:

Results:

NOTE: If the source Datetime value does not contain a valid input for one of these functions, no value is returned.