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

...

Integer literal values:

DATEFORMATTIME
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
dateformat(
time(23,58,59),'HH mm ss')

...

dateformat(time(23,58,59),'HH mm ss')

Output: Returns the following map:

Code Block
23 58 59

Column reference values:

DATEFORMATTIME
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
dateformat(
time(myHour, myMinute, mySecond), 'hh-mm-ss')

dateformat(time(myHour, myMinute, mySecond), 'hh-mm-ss')

Output: Generates a column of values where:

  • hh = values from myHour column
  • mm = values from myMinute column
  • ss = values from mySecond column

D s
snippetSyntax

DATEFORMATTIME
d-codelang-syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value:
dateformat(
time(hour_integer_col,minute_integer_col,second_integer_col ),'time_format_string')

dateformat(time(hour_integer_col,minute_integer_col,second_integer_col ),'time_format_string')


ArgumentRequired?Data TypeDescription
hour_integer_colYintegerName of column or Integer literal representing the hour value to apply to the function
minute_integer_colYintegerName of column or Integer literal representing the minute value to apply to the function
second_integer_colYintegerName of column or Integer literal representing the second value to apply to the function
time_format_stringYstringString literal identifying the time format to apply to the value

...