Format date with custom format¶
Format data in standard ISO-8601 format (yyyy-MM-ddTHH:mm:ss.SSSZ) to another custom date format. Use this processor to convert an ISO-8601 date into a string that may be easier to read.
Options¶
Input column
Column containing data in ISO-8601 format. Use a Prepare step to parse your data into this format if it isn’t already.
Date format
Specify the custom date format of the output column using the Java syntax for date specifier.
Note
Common patterns include y (year), M (month in year), w (week in year), d (day in month), E (day name in week), a (am/pm marker), H (hour in day 0-24), h (hour in am/pm 1-12), m (minute in hour), s (second in minute), S (millisecond), Z (time zone).
Locale
Translate date information in locale format (like ‘mercredi’ or ‘janvier’ in French).
Timezone
Change the timezone from the UTC default. Options include using a TZ column, an IP column, or specifying a timezone from the dropdown.
Output column
Leave blank to format data in place, or create a separate output column.
Warning
If the output format is not ISO-8601, DSS will treat it as an unparsed date.