Date format definition
This section explains how to describe formats for the date logics that are used in Mapper for HULFT IoT EdgeStreaming.
For the following fields, define the date format you want to use following the examples under "Characters" in the date format table:
-
From the Mapper editor tool palette, select the Date > Calculation > Parse of date/time(Custom) logic.
Layout on the properties screen for the Parse of date/time(Custom) logic
-
From the Mapper editor tool palette, select the String > Date > Date/Time formatting(Custom) logic.
Format on the properties screen for the Date/Time formatting(Custom) logic
Date format
|
Characters |
Description |
Example |
|
2006 |
Year (four digits) |
2021 |
|
06 |
Year (two digits) |
21 |
|
January |
Month |
March |
|
Jan |
Month (abbreviation) |
Mar |
|
01 |
Month (always 2 digits) |
03, 12 |
|
1 |
Month |
3, 12 |
|
02 |
Day (always 2 digits) |
09, 21 |
|
2 |
Day |
9, 21 |
|
Monday |
Day of the week |
Wednesday |
|
Mon |
Day of the week (abbreviation) |
Wed |
|
15 |
Hour (24-hour format, always two digits) |
06, 23 |
|
03 |
Hour (12-hour format, always two digits) |
06, 11 |
|
3 |
Hour (12-hour format) |
6, 11 |
|
PM |
AM/PM (upper case) |
AM |
|
pm |
AM/PM (lower case) |
pm |
|
04 |
Minute (always two digits) |
08, 45 |
|
4 |
Minute |
8, 45 |
|
05 |
Second (always two digits) |
04, 29 |
|
5 |
Second |
4, 29 |
|
MST (*1) |
Time zone |
JST, UTC |
|
Z0700 |
Time zone |
+0900, Z |
|
Z07:00 |
Time zone |
+09:00, Z |
|
-0700 |
Time zone |
+0900, +0000 |
|
-07 |
Time zone |
+09, +00 |
|
-07:00 |
Time zone |
+09:00, +00:00 |
|
*1 |
: |
The time zone abbreviations that can be converted to the correct date and time depend on the location of the OS that runs EdgeStreaming Runtime. If an abbreviation that differs from the time zone of the OS that is running EdgeStreaming Runtime is specified, it cannot be converted to the correct date and time. If this happens, the information of the specified time zone is lost, and the abbreviation is handled as if UTF is specified. |
Examples:
-
If you enter "2006-01-02T15:04:05.999999999Z07:00" for Format on the properties screen of the Date/Time formatting(Custom) logic and specify "2021/5/1 8:50:44 (JST)" in the TimeStamp type for the input data, the data output is "2021-05-01T08:50:44+09:00".
-
If you enter "2006/01/02 15:04:05Z0700" for Layout on the properties screen of the Parse of date/time(Custom) logic and specify "2021/04/29 13:22:55+0900" as a string for the input data, the data string is correctly parsed in TimeStamp type and is output.