Date and Time Data

Question 1

Fill in the Blank:

KNIME provides a number of nodes for tasks that are specific to date and time values.

1. For example, you can calculate the number of days between two Date&Time values with the __________ node.
2. You can calculate a timestamp as defined by a distance to another Date&Time value with the __________ node.
3. You can also filter data by a specific month or any other time range with the __________ node.
4. Date&Time values are also supported by many other nodes. You can for example visualize time series with the __________ node and show the Date&Time values on the x-axis.

Answer 1

1. Date&Time Difference
2. Date&Time Shift
3. Date&Time-based Row Filter
4. Line Plot

Question 2

You have a data table with the purchase date and time and number of purchased items. You want to visualize the number of purchased items per hour on different weekdays in a line plot. Which GRANULARITIES do you need to extract from the Date&Time values to be able to visualize the supermarket peak hours?

Answer 2

Day of week and Hour

Question 3

Combine the date formats with the string representations of the date and/or time values.
Date: 24/12/2003

Answer 3

dd/MM/yyyy

Question 4

Combine the date formats with the string representations of the date and/or time values.
Date: 1994-03-16

Answer 4

yyyy-MM-dd

Question 5

Combine the date formats with the string representations of the date and/or time values.
Time: 12:34

Answer 5

HH:mm

Question 6

Combine the date formats with the string representations of the date and/or time values.
Date: 23.09.1984 17:56:00

Answer 6

dd.MM.yyyy HH:mm