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:


DATEFORMAT(DATETIME
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
dateformat(datetime(2015,02,15, 2, 4, 0),'yyyy-MM-dd:HH:mm:ss')

dateformat(datetime(2015,02,15, 2, 4, 0),'yyyy-MM-dd:HH:mm:ss')

Output:

...

Returns the formatted date value: 2015-02-15:02:04:00.

Column reference values:

DATEFORMAT( DATETIME
d-code-lang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
dateformat(datetime(myYear, myMonth, myDay, myHour, myMin, mySec),'MMM yyyy - HH:MM:SS')

dateformat(datetime(myYear, myMonth, myDay, myHour, myMin, mySec),'MMM yyyy - HH:MM:SS')


Output:
Generates a column of date values where:

  • MMM = short value for myMonth
  • yyyy = value from myYear
  • HH = value from myHour
  • MM = value from myMin
  • SS = value from mySec

D s
snippetSyntax

DATEFORMATDATETIME
d-code-lang-syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value:
dateformat(
datetime(year_integer_col,month_integer_col,day_Integer_col, hour_Integer_col, minute_Integer_col,second_Integer_col ),'date_format_string')

dateformat(datetime(year_integer_col,month_integer_col,day_Integer_col, hour_Integer_col, minute_Integer_col,second_Integer_col  ),'date_format_string')


ArgumentRequired?Data TypeDescription
year_integer_colYintegerName of column or Integer literal representing the year value to apply to the function
month_integer_colYintegerName of column or Integer literal representing the month value to apply to the function
day_integer_colYintegerName of column or Integer literal representing the day value to apply to the function
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 day second to apply to the function
date_format_stringYstringString literal identifying the date format to apply to the value

...