ho to subtract a fixed time from a DateAndTime column

Hi Everyone,

I have a DateAndTime column which I need to convert to local time by subtracting 10.5 hrs.
If a record has “22.Aug.208 10:30:00” as a value the I want it as “22.Aug.208 00:00:00”
How can I achieve that

With the date and time shift node :slight_smile:
https://hub.knime.com/knime/nodes/DateTime_Shift*V9O76SFdOZM1JjE1

And if you want to know more about all those date and time nodes, I once wrote a blog post about this.
https://www.knime.com/blog/the-new-date-time-integration

Cheers, Iris

1 Like