Increases or decreases hour

Logic name

Increases or decreases hour

Function

This logic increases or decreases the hour of the input date and time and returns the date and time value.

Data type

Property

Function details

Calculation method

This logic adds the numerical value of the second input handler in hours to the date and time of the first input handler. You can specify only an integer as a number.

Notes

• If a nonexistent date and time is input, or if such a calculation result is obtained, it is automatically corrected to an existing date and time. For example, 2021/04/30 25:00:00 becomes 2021/05/01 01:00:00.

• The maximum and minimum values of the second input handler (upper connecting line) are as follows:

  Maximum: 24

  Minimum: -24

  If you enter a value outside of the above range for the second input handler, the calculation result value overflows. Specify an input value within the range.

• If you enter a floating point in the second input handler, an error such as the following occurs:

  2021-02-12T17:13:06 A tuple was dropped from the topology
  EES0AGENT01711,[unsupported cast int from float]
  map[data:{} timestamp:\"2021-02-12T17:13:06.1596229+09:00\"]

Example of logic use

Mapping definition