Time calculation

KNIME Extensions
1

LS,

I can't find a way to add eg 30 minutes to a time field like 12:45.

So how can I add or substract minutes to hours ?

Thanks,

Arthur

2

Dear Arthur,

we currently don't have a node which can do that job. But it is under planing.

 

However you can use the java snippet to return the string, and convert it with a string to date time back.

 

Here's an examplary code for the java snippet, which add 30minutes to the column

 

SimpleDateFormat dataFormat = new SimpleDateFormat("yyyy-MM-dd'T'hh:mm:ss");

int min = 30;

Date value;
try {
  value = dataFormat.parse($Date and time$);
} catch (Exception e) {
  throw new Abort("Unable to parse value: " + $Date and time$, e);
}

long t = value.getTime();
t+= 1000*60*min;
value.setTime(t);
DateFormat df = DateFormat.getDateInstance();

return dataFormat.format(value);

3

Hi Iris,

When are you planning to release this node?

I have some columns with time data and I want to sum up them by columns or by rows. How can I do it?

Thanks for your help.

4

I agree this is a much needed node. I have wanted to add 1 day or 1 week to some date times but been unable too due my java phobia.

 

Also when do we get this pink Iris node :-)

 

simon