This node calculates date and time string by copying time format string and replacing each of the time format codes with the corresponding values.
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|
|%p||AM or PM flag||AM or PM|
|%<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|
|%.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.|
|%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: %c—Corresponds to the locale-specific date/time representation.
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: The current date and time
timestamp formatted by the code specified in time format string.