Parse to standard date format¶
Parse strings containing dates in any format into the standard ISO 8601 format (yyyy-MM-ddTHH:mm:ss.SSSZ
) to work with them in DSS. Use Smart Dates to get semi-automatic date parsing with the assistance of DSS.
Options¶
Column
Apply date parsing to the following:
A single column
An explicit list of columns
All columns matching a regex pattern
All columns
Output column
Leave blank to parse data in-place or create a separate output column.
Input date format(s)
Open Find with Smart Date to get semi-automatic date parsing with the help of DSS. Otherwise, specify the format of your inputs column(s) using the Java syntax for date specifiers.
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
Provide details on the time zone, if needed. Options include using a TZ column, an IP column, or specifying a timezone from the dropdown. UTC is the default.