Date&Time to String

Converts date&time values to string representations using a user-defined format pattern. Locales can be specified to handle localized month or weekday names. Use this node to create customized date&time string formats.
Often used to export date&time data in a specific format for reports, files, or external systems.

Options

Date&time columns
The date&time columns to convert to string columns.
Locale
The locale to use for formatting the date&time. Names of months and days of the week will be translated according to the selected locale.
Output format
A format string (defined by DateTimeFormatter).
Examples:
  • "yyyy.MM.dd HH:mm:ss.SSS" produces dates such as "2001.07.04 12:08:56.000"
  • "yyyy-MM-dd'T'HH:mm:ss.SSSZ" produces dates such as "2001-07-04T12:08:56.235-0700"
  • "yyyy-MM-dd'T'HH:mm:ss.SSSXXX'['VV']'" produces dates such as "2001-07-04T12:08:56.235+02:00[Europe/Berlin]"
Supported placeholders in the pattern are:
  • G: era
  • u: year
  • y: year of era
  • D: day of year
  • M: month in year (context sensitive)
  • L: month in year (standalone form)
  • d: day of month
  • Q/q: quarter of year
  • Y: week based year (you probably want to use y instead)
  • w: week of week based year
  • W: week of month
  • E: day of week
  • e: localized day of week
    • e: 4
    • ee: 04
    • eee: Wed
    • eeee: Wednesday
    • eeeee: W
  • c: day of week
  • F: day-of-week in month
  • a: am/pm of day
  • h: clock hour of am/pm (1-12)
  • K: hour of am/pm (0-11)
  • k: clock hour of am/pm (1-24)
  • H: hour of day (0-23)
  • m: minute of hour
  • s: second of minute
  • S: fraction of second
  • A: milli of day
  • n: nano of second
  • N: nano of day
  • V: time zone ID
  • z: time zone name
  • O: localized zone offset
  • x: zone offset (ISO8601)
    • X: +08 or +0830
    • XX: +0800 or +0830 (no colons)
    • XXX: +08:00 or +08:30 (with colons)
    • XXXX: +0800 or +083015 (i.e. including offset seconds, no colons)
    • XXXXX: +08:00 or +08:30:15 (i.e. including offset seconds, with colons)
  • X: same as x, but outputs Z when offset is 0
  • Z: zone offset (RFC822)
    • Z, ZZ, ZZZ: +0800 or +0830
    • ZZZZ: GMT+08:00 or GMT+08:30
    • ZZZZZ: +08:00 or +08:30:15
  • p: pad next
  • ' : escape for text
  • '': single quote
  • [: optional section start
  • ]: optional section end
Output columns
Depending on this setting, the output columns will either replace the modified columns, or be appended to the table with a suffix.
  • Replace: Replaces the selected columns by the new columns.
  • Append with suffix: Appends the selected columns to the input table with a new name that is the previous name plus the provided suffix.
Output column suffix
The suffix to append to the column names of the new columns.

Input Ports

Icon
Input table containing date&time columns.

Output Ports

Icon
Output table with date&time columns converted to string columns.

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

  • No workflows found

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.