Parse Date/Time

Parse of date/time(Standard format)

Logic name

Parse Date/Time (Document Mapper/Variable Mapper/Merge Mapper)

Function

This logic parses the input string in a specified format and outputs the value as date/time.

Data types

Location

Type

First input handler

String

Logic output

Date

= Hint =

Refer to the following for details:

Properties

Category

Property

Description

Required settings

Format

Specify the date format of the custom type.

Comment

Comment

You can write a description of the logic. It doesn't affect the conversion process.

Function details

Format

Format is used in order to interpret a string as date/time.

Specify the format that fits the input string.

= Remarks =

Refer to Format of the Data/Time Formatting logic for details of format.

= Hint =

The following exception is output when the string can't be interpreted as date/time using the specified format.

[Mapping] process failed. Caused by:[java.lang.IllegalStateException: failed to set value to variable "date" ("20061001" cannot be parsed in "yyyy/MM/dd" format)]

Logic sample

Mapping definition

Logic settings and processing result

The logic parses date/time strings in the input data with format "yyyy/MM/dd" and outputs the result as date/time data.

Property settings

Property

Setting

Format

yyyy/MM/dd

Input data

1999/08/10

2001/09/01

2004/10/17

Output data

1999-08-10T00:00:00.000+0900

2001-09-01T00:00:00.000+0900

2004-10-17T00:00:00.000+0900

 

= Hint =

For a list of logics, refer to Mapper Logic Guide.