Format Date and Time String

Converts a timestamp or numeric value into a string that displays the corresponding time.

This node calculates date and time string by copying time format string and replacing each of the time format codes with the corresponding values.

1378

Inputs/Outputs

datatype_icon

time format string

Format of the output string.

The syntax for this string is %<optional #><format code>.

The # modifier removes the leading zeros from the output of %d, %H, %I, %j, %m, %M, %S, %U, %w, %W, %X, %y, %Y. By default, the output contains leading zeros as necessary to ensure a constant field width.

This node uses the following format codes to interpret timestamp:

Time Format Code Definition Values
%a Abbreviated weekday name. This node returns a numeric value for systems that do not support abbreviated names, such as Chinese and Korean. Sun - Sat
%A Full weekday name Sunday - Saturday
%b Abbreviated month name. This node returns a numeric value for systems that do not support abbreviated names, such as Chinese and Korean. Jan - Dec
%B Full month name January - December
%c Locale-specific default date and time
%d Day of month 01-31
%H Hour (24-hour clock) 00-23
%I Hour (12-hour clock) 01-12
%j Day number of the year 001-366
%m Month number 01-12
%M Minute 00-59
%p AM or PM flag AM or PM
%S Second 00-59
%<digit>u Fractional seconds with <digit> precision
%U Week number of the year, with the first Sunday as the first day of the first week 00-53
%w Weekday as a decimal number, with 0 representing Sunday 0-6
%W Week number of the year, with the first Sunday as the first day of the first week 00-53
%x Locale-specific date
%.1x Long date format
%.2x Abbreviated long date format. This node returns a numeric value for systems that do not support abbreviated names, such as Chinese and Korean.
%X Locale-specific time
%y Year within century 00-99
%Y Year, including the century 1997, for example
%z Difference between locale time and universal time HH:MM:SS
%Z Time zone name or abbreviation
Literal text Literal text

Default value: %c—Corresponds to the locale-specific date/time representation.

datatype_icon

timestamp

The time that you want to convert.

The year in this timestamp must be between 1600 and 3000.

If you wire a numeric value to this input, the node interprets the number as the time-zone-independent number of seconds that have elapsed since 12:00 a.m. on January 1, 1904, Universal Time [01-01-1904 00:00:00]. The node interprets a negative number as the number of seconds before this time.

Default value: The current date and time

datatype_icon

UTC format

Boolean value that specifies whether the output string is in Universal Time or in the configured time zone for the computer.

True date and time string is in Universal Time.
False date and time string is in the configured time zone for the computer.

Default value: False

datatype_icon

date and time string

timestamp formatted by the code specified in time format string.