Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

  •  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 s
snippetBasic

UNIXTIME
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
unixtime(MyDate)

unixtime(MyDate)

Output:

...

Returns the Unix time values from the MyDate column.

D s
snippetSyntax

UNIXTIME
d-codelang-syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value:
unixtime(datetime_col)

unixtime(datetime_col)


ArgumentRequired?Data TypeDescription
datetime_colYdatetimeName of column whose Unix time values are to be computed

...