Operating with dates

Dates are one of the most common data types and there is a vast set of operations that you may need to apply to Date fields:

  • Extracting parts of a date, for example, the year
  • Given a date, getting some descriptions, for example, the weekday
  • Adding dates
  • Comparing dates

PDI offers a lot of possibilities to manipulate Date fields. However, these features are not organized in a single place inside Spoon. There are several steps in different steps categories that allow you to manipulate dates. Also, given a particular operation, there is usually a couple of ways to perform it. This section is meant to present you the different options.

Get Learning Pentaho Data Integration 8 CE - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.