Date&Time Format Manager

Attaches display formatting to date&time columns. This node changes how date&time values are displayed in views, such as the Table View, without modifying the data. Locales can be specified for localized terms.
Helpful for formatting date&time values for display in reports or data apps.

Options

Date&time columns

The date&time columns to create a formatter for.

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.

Date&time 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"
• "GGGG: yyyy-MMMM-dd ' at 'HH:mm[:ss[.SSS]] 'in' VV[' [also known as 'zzzz']']" produces dates such as "Anno Domini: 2024-November-26 at 22:37:59.674 in Europe/Berlin [also known as Central European Standard Time]"

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

Alignment suggestion

Position the value horizontally in compatible views like the Table View.

• Left: Align the text to the left.
• Center: Center the text.
• Right: Align the text to the right.

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers