Overview
Timestamps represent the date and time of an event and can be represented in different formats.
This article will provide additional information to assist the user with timestamp configuration to ensure a match between the timestamp data being imported and the time configuration in the File Import profile.
Time Format Token Reference
Tokens are the means by which the time format must be expressed. The reference table below shows allowable formats for each time unit.
| Time Unit | Token | Output |
| Month | M | 1 2 ... 11 12 |
| Mo | 1st 2nd ... 11th 12th | |
| MM | 01 02 … 11 12 | |
| MMM | Jan Feb … Nov Dec | |
| MMMM | January February … December | |
| Day of Month | D | 1 2 … 29 30 |
| Do | 1st 2nd ... 29th 30th | |
| DD | 01 02 … 28 30 | |
| Day of Year | DDD | 1 2 … 364 365 |
| DDDo | 1st 2nd ... 364th 365th | |
| DDDD | 001 002 … 364 365 | |
| Day of Week | d | 0 1 … 5 6 |
| do | 0th 1st … 5th 6th | |
| dd | Su Mo … Fr Sa | |
| ddd | Sun Mon … Fri Sat | |
| dddd | Sunday Monday … Friday Saturday | |
| Day of Week (Locale) | e | 0 1 … 5 6 |
| Day of Week (ISO) | E | 1 2 … 6 7 |
| Week of Year | w | 1 2 … 52 53 |
| wo | 1st 2nd … 52nd 53rd | |
| ww | 01 02 … 52 53 | |
| Year | YY | 70 71 … 29 30 |
| YYYY | 1970 1971 … 2029 2030 | |
| Week Year | gg | 70 71 … 29 30 |
| gggg | 1970 1971 … 2029 2030 | |
| Week Year (ISO) | GG | 70 71 … 29 30 |
| GGGG | 1970 1971 … 2029 2030 | |
| AM/PM | A | AM PM |
| a | am pm | |
| Hour | H | 0 1 … 22 23 |
| HH | 00 01 … 22 23 | |
| h | 1 2 … 11 12 | |
| hh | 01 02 … 11 12 | |
| Minute | m | 0 1 … 58 59 |
| mm | 00 01 … 58 59 | |
| Second | s | 0 1 … 58 59 |
| ss | 00 01 … 58 59 | |
| Fractional Second | S | 0 1 … 8 9 |
| SS | 0 1 … 98 98 | |
| SSS | 0 1 … 998 999 | |
| Timezone | Z | -07:00 -06:00 ... +06:00 +07:00 |
| ZZ | -0700 -0600 ... +0600 +0700 | |
| Unix Timestamp | X | 136001326 |
| Unix MS Timestamp | x | 1360013296000 |
Note: Timestamp data frequency up to 1 KHz is supported. Time format will only be stored up to 3 decimal places in the fractional second. Example: YYYY-MM-DD HH:mm:ss.SSS
Time Format
This section will cover some Time Format examples to aid the user in matching data formatting with timestamp configuration requirements in the File Import module.
This is a theoretical example of formatting match:
Data File Timestamp: 2021-06-01 22:38:00
iTwin IoT Timestamp token configuration: YYYY-MM-DD HH:mm:ss
Below are some examples of formatting matches in the module: