[Merge Mapper]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

Refer 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

If a wrong date is entered or gained as a result of operation, it automatically compensates for an existing date (e.g. 04/31/2013 → 05/01/2013)

Logic Sample

Mapping Definition

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