Extract date elements

This processor takes a column containing a date in standard ISO8601 format (ie, detected with meaning ‘Date’) and extracts various elements from this date to other columns

Each output column is optional. If you leave them empty, the corresponding information will not be extracted.

Please refer to DSS User’s Guide for more information about dates management. Timezones handling ——————

This processor provides timezone change features. Please refer to the DSS User’s Guide for more information.

Output values

  • Month: 1-12
  • Day: 1-31
  • Day of week: 1-7 (1= Sunday, 7 = Saturday)
  • Week of year: 1-53
  • Timestamp: UNIX timestamp of the date (in seconds since Epoch)