EXAMPLE - Unixtime Functions
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. SeeUNIXTIME Function.UNIXTIMEFORMAT- Formats a Unix time value in the specified manner. See UNIXTIMEFORMAT Function.
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 |