...
- If you have a column with multiple time zones, you can convert the column to Unixtime so you can perform Date/Time operations with a standardized time zone.
- If you want to work with local times, you can truncate the time zone or use other Date functions.
- If the source Datetime value does not include a valid input for this function, a missing value is returned.
| d-codelang-syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value: |
|---|
| UNIXTIME |
unixtime(MyDate) |
Output:
...
Returns the Unix time values from the MyDate column.
| d-code-lang-syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value: |
|---|
| UNIXTIME |
unixtime(datetime_col) |
| Argument | Required? | Data Type | Description |
|---|
| datetime_col | Y | datetime | Name of column whose Unix time values are to be computed |
...
