Parse of date/time(Standard format)
Logic name
Parse of date/time(Standard format)
Function
This logic outputs the input string as date and time according to the selected layout.
Data type
|
Location |
Type |
|---|---|
|
First input handler |
String |
|
Logic output |
Date |
Property
|
Category |
Property |
Description |
|---|---|---|
|
Required |
Layout |
Select the date format. |
|
Required |
Input format |
The output sample of the selected layout is displayed. This item cannot be input. |
|
Comment |
Comment |
It does not affect the conversion processing. |
Function details
For the date and time format, refer to Date format definition in Points to be noted on operation.
Select a format from the following standard formats:
-
YYYYMMDDThhmmss+0000
-
YYYY-MM-DDThh:mm:ss+00:00
-
YYYY/MM/DD hh:mm:ss
-
MM/DD/YYYY hh:mm:ss
-
DD/MM/YYYY hh:mm:ss
-
hh:mm:ss YYYY/MM/DD
-
hh:mm:ss MM/DD/YYYY
-
hh:mm:ss DD/MM/YYYY
-
Mon MMM DD hh:mm:ss YYYY
-
Mon MM DD hh:mm:ss YYYY
-
YYYY-MM-DD
-
YYYYMMDD
-
YYYY/MM/DD
-
hh:mm:ss
You can add the following options to the standard formats:
-
Add a time zone
-
Output in 12-hour format
-
Add milliseconds
Setting example of format
|
Setting Example of Format |
Output Result |
|---|---|
|
YYYY/MM/DD hh:mm:ss |
2021/01/23 12:34:56 +09:00 |
|
YYYY/MM/DD hh:mm:ss |
2021/01/23 12:34:56 PM |
|
YYYY/MM/DD hh:mm:ss |
2021/01/23 12:34:56.789 |
|
YYYY/MM/DD hh:mm:ss |
2021/01/23 12:34:56.789 PM +09:00 |
The result is interpreted date and time data that indicates Japan time 12:34:56.789, January 23, 2021 for the Japanese locale.
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 |
YYYY/MM/DD |
|
(Option) |
Add a time zone |
Input data
|
1999/08/10 +00:00 |
|
2001/09/01 -12:10 |
|
2021/03/17 +08:20 |
Output data
|
1999-08-10T00:00:00Z |
|
2001-09-01T00:00:00-12:10 |
|
2021-03-17T00:00:00+08:20 |