How to add or subtract time from date/time field

rleyba
53 ●2 ●5 ●8

Hi Team,

I have a requirement where I would want to add some hours or minutes to my time variable.

For example: How would I do this?

${time:now()} - 4 hours.

I want to do add/subtract from current time like how they do it in bash --> https://stackoverflow.com/questions/4...

Thanks and regards.

1 Answer

Sort by » oldest newest most voted

You can do this by converting the DateTime to a long, performing the arithmetic, then converting it back:

${time:millisecondsToDateTime(time:dateTimeToMilliseconds(time:now()) - (4 * 3600 * 1000))}

If you have ideas on how this could be done more elegantly, then please feel free to submit an enhancement request at https://issues.streamsets.com/

Yes, understood. This solution will work for me. Thanks very much.

rleyba ( 2018-07-24 05:59:27 -0500 )edit

Could you help me understand how to put this into 'UTC', 'yyyy-MM-dd\'T\'HH:mm:ss.SSS')}

spadez8 ( 2019-06-05 08:32:34 -0500 )edit

1 follower

Asked: 2018-07-21 20:52:35 -0500

Seen: 593 times

Last updated: Jul 23 '18