Parse of date/time(Custom)
Logic name
Parse of date/time(Custom)
Function
This logic outputs the input string as date and time according to the specified layout.
Data type
|
Location |
Type |
|---|---|
|
First input handler |
String |
|
Logic output |
Date |
Property
|
Category |
Property |
Description |
|---|---|---|
|
Required |
Layout |
Specify a custom-type date layout. |
|
Comment |
Comment |
It does not affect the conversion processing. |
Function details
Layout
The format is used to interpret character strings as date and time.
Specify the format that corresponds with the input character string of date and time.
-
For formats, refer to Format in Date/Time formatting(Custom) logic.
-
When the date and time character string cannot be interpreted in the specified format during Runtime execution, the following error is output:
A tuple was dropped from the topology parsing time <input data> as <layout>: cannot parse <location within the input data that could not be parsed> as <location within the layout that conflicts with the input data>
Example of logic use
Mapping definition
Logic settings and processing result
This logic interprets the date and time character strings of the input data in the layout "YYYY/MM/DD" and outputs it as date/time-type data.
Property settings
|
Property |
Setting Value |
|---|---|
|
Layout |
2006/01/02 |
Input data
|
1999/08/10 |
|
2001/09/01 |
|
2021/03/17 |
Output data
|
1999-08-10T00:00:00Z |
|
2001-09-01T00:00:00Z |
|
2021-03-17T00:00:00Z |