Nominal to Date


Synopsis

Parses the nominal values for the specified attribute with respect to the given date format string and transforms the values into date values.


Description

This operator parses given nominal attributes in order to create date and / or time attributes. The date format can be specified by the date_format parameter. The old nominal attribute will be removed and replaced by a new date attribute if the corresponding parameter keep_old_attribute is not set (default).


Date and Time Patterns

Date and time formats are specified by date and time pattern strings in the date_format parameter. Within date and time pattern strings, unquoted letters from 'A' to 'Z' and from 'a' to 'z' are interpreted as pattern letters representing the components of a date or time string. Text can be quoted using single quotes (') to avoid interpretation. "''" represents a single quote. All other characters are not interpreted; they're simply copied into the output string during formatting or matched against the input string during parsing.

The following pattern letters are defined (all other characters from 'A' to 'Z' and from 'a' to 'z' are reserved):

Pattern letters are usually repeated, as their number determines the exact presentation:

Otherwise, calendar system specific forms are applied. If the number of pattern letters is 4 or more, a calendar specific long form is used. Otherwise, a calendar short or abbreviated form is used.

This operator also supports localized date and time pattern strings by defining the locale parameter. In these strings, the pattern letters described above may be replaced with other, locale dependent, pattern letters.


Examples

The following examples show how date and time patterns are interpreted in the U.S. locale. The given date and time are 2001-07-04 12:08:56 local time in the U.S. Pacific Time time zone.


Input

, expects: ExampleSet


Output


Parameters


ExampleProcess