Calculate Second

Logic Name

Calculate Second

Function

Increases or decreases the second of the input date/time and returns the date/time value.

Data Types

Location Type
The first input handler Date
The second input handler Numeric
Logic output Date
lightbulbRefer to "Logic Specifications" for details.

Properties

Category Property Description
Comment Comment The comment will also be output to the specifications.It does not affect the conversion process.

Function Details

Calculation

The logic adds the numeric value of the second input handler in seconds to the date/time of the first input handler.Digits after the decimal point are round off.

The first input handler (date/time) The second input handler (number of seconds) The output date/time
2005-01-01T00:00:00+0900 1 2005-01-01T00:00:01+0900
2005-01-01T00:00:00+0900 1.23 2006-01-01T00:00:01+0900
2005-01-01T00:00:00+0900 -1 2004-12-31T23:59:59+0900
2005-01-01T00:00:00+0900 61 2001-01-01T00:01:01+0900

Notes

Logic Sample

Mapping Definition

Calculate Second

Logic Settings and Processing Result

The logic increases or decreases the second of the input date/time and outputs the date/time value.
Property Settings
Property Setting
None  
Input Data
2007-01-01T00:00:01.000+0900,-2
2008-02-02T02:00:20.000+0900,8
2009-03-03T03:00:45.000+0900,50
Result Data
2006-12-31T23:59:59.000+0900
2008-02-02T02:00:28.000+0900
2009-03-03T03:01:35.000+0900