Page tree

NOTE:  Trifacta Wrangler is a free product with limitations on its features. Some features in the documentation do not apply to this product edition. See Product Limitations.

   

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

Functions:

ItemDescription
UNIXTIME Function Derives the Unixtime (or epoch time) value from a Datetime value. Source value can be a reference to a column containing Datetime values.

Source:

date
2/8/16 15:41
12/30/15 0:00
4/26/15 7:07

Transformation:

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

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula UNIXTIME (date)
Parameter: New column name 'unixtime_date'

Results:

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

dateunixtime_date
2/8/16 15:411454946120000
12/30/15 0:001451433600000
4/26/15 7:071430032020000

See Also for EXAMPLE - Unixtime Functions:

This page has no comments.