Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

Release 8.2.1



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


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


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'


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

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

  • No labels

This page has no comments.