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 |
|
|---|---|
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 |