Datetime
Last updated
Was this helpful?
Last updated
Was this helpful?
Change the imported data to date-time format.
Timezone before conversion: Select the timezone of the imported data. The default timezone is Seoul (GMT +9).
Display format: Select the same format as the imported data. If the format is not listed, you can enter it manually in the input field.
Here is the translated format guide, keeping the original structure intact:
yyyy : Year (e.g. 2022)
MM : Month (e.g. 06)
MMM : Month (e.g. Jan)
MMMM : Month (e.g. January)
dd : Day (e.g. 09)
EEE : Day of week (e.g. Mon)
EEEE : Day of week (e.g. Monday)
HH : Hour - 24-hour format (0–23) (e.g. 22)
hh : Hour - 12-hour format (1–12) (e.g. 05)
mm : Minutes (e.g. 02)
ss : Seconds (e.g. 32)
SSS : Milliseconds (e.g. 324)
T : Delimiter between date and time
Z : Timezone based on GMT+0
a : AM/PM (e.g. 00:00 a.m.)
b : AM/PM (e.g. 00:00 PM)
yyyyMMdd
20231231
yy-MM-dd HH:mm
22-06-09 05:02
yy-MM-dd H:m
22-06-09 5:2
M/d/yy H:m
6/9/22 5:2
M. d. yy
6. 9. 22
MM. dd
06. 09
M/d/yyyy
6/9/2022
yyyy/MM/dd hh:mm:ss a
2023/01/01 05:05:11 am
yyyy/MM/dd hh:mm:ss b
2023/01/01 05:05:11 AM
Here is the English translation of your formatting instructions, keeping the original structure:
If there are spaces in the original data, be sure to include the same spaces in the format string.
am or pm should be placed at the beginning or end of the datetime string.
For example: 2023/01/01 PM 11:22:33 may not be parsed correctly if the AM/PM is in the middle.
'yy' (two-digit year) should only be used at the end of the format.
Example: "MM-dd-yy"
'y' or 'yyyy' can be used at either the beginning or the end of the format string.
If 'Z' is included in the format, the time zone will be fixed to GMT+0, which is the Coordinated Universal Time (UTC) based on London.
Please note: If the format of the imported data does not match the display format, the transformation will not work properly. Be sure the format you specify exactly matches the structure of your source data.
Please follow the same procedure as above to set the timezone and display format.
If the data is updated successfully, it will be transformed into the specified date-time format. If there is an error in the configuration, the data will be shown as N/A. You can hover over each cell to view the original, unformatted data.
