Skip to main content

EXAMPLE - Unixtime Functions

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

Functions:

Item

Description

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.

date

unixtime_date

2/8/16 15:41

1454946120000

12/30/15 0:00

1451433600000

4/26/15 7:07

1430032020000