Calculate Period by Second
Logic name
Calculate Period by Second (Document Mapper/Variable Mapper/Merge Mapper)
Function
This logic calculates a period between the two input date/time values and returns the result by second.
Data types
|
Location |
Type |
|---|---|
|
First input handler |
Date |
|
Second input handler |
Date |
|
Logic output |
Numeric |
Refer to the following for details:
-
Logic specifications (Document Mapper/Variable Mapper)
-
Logic specifications (Merge Mapper)
Properties
|
Category |
Property |
Description |
|---|---|---|
|
Comment |
Comment |
You can write a description of the logic. It doesn't affect the conversion process. |
Function details
The logic calculates the period from the date/time of the first input handler to that of the second input handler by second.
The value will be negative if the date/time of the first input handler is in the future relative to the date/time of the second input handler.
Any fraction smaller than a second in the difference between two date/time values is rounded down and the number of seconds is returned as a numeric character.
Logic sample
Mapping definition
Logic settings and processing result
The logic calculates a period from two date/time values.
Property settings
|
Properties |
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 |
Output data
|
90090 |
|
-90 |
|
1 |
For a list of logics, refer to Mapper Logic Guide.