[Document Mapper]Calculate Period by Second

Logic Name

Calculate Period by Second

Function

Calculates period between the two inputs and returns the value by second.

Data Types

Location	Type
The first input handler	Date
The second input handler	Date
Logic output	Numeric

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

The logic calculates the period from the date/time of the first handler to that of the second handler by second.
The value will be negative if the date/time of the first handler is the future than that of the second handler.
values is round down and the number of seconds is returned in numeral.

Logic Sample

Mapping Definition

Logic Settings and Processing Result

The logic calculates the period from two date/time values.

Property Settings

Property	Setting
None

Input Data

2010-05-11T00:00:00.000+0900,2010-05-12T01:01:30.000+0900

2010-05-11T00:01:30.000+0900,2010-05-11T00:00:00.000+0900

2010-05-11T09:30:00.000+0900,2010-05-11T09:30:01.999+0900

Result Data

90090

-90