EXAMPLE - Unixtime Functions

Contents:

Expand all Collapse all

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:

Transform:

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

derive type:single value: UNIXTIME (date)

Results:

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