Date-time display examples
Here are the display styles that you can choose from.
When choosing a code, remember that you can choose only one style, either EN or JP, for a company. You can't choose to use both.
- 01:43 pm
- HH_MM_A
- 01:43 PM
- HH_MM_CAPA
- 1:43 pm
- H_MM_A
- 1:43 PM
- H_MM_CAPA
- 13:44
- HH_MM
- 9:44
- H_MM
- 13:45:12
- HH_MM_SS
- 13:45:44 PM
- HH_MM_SS_A
- 8:45:12
- H_MM_SS
- 8:45:44 PM
- H_MM_SS_A
- 18:42:59
- JA_TIME_HH_MM_SS
- 18:45
- JA_TIME_HH_MM
- 01時47分 午後
- JA_TIME_HH_MM_A
- 午後01時47分
- JA_TIME_SYM_HH_MM
- 2020年9月7日
- JA_DATE
- 2020年 09月
- JA_DATE_YYYY_MM
- 09月07日
- }JA_MMM_DD
- 15 Apr 2020
- DD_MMM_YYYY
- 2020 09
- YYYY_MM
- Mon, 19 Mar, 9:32 AM
- DAY_DD_MMM-TIME
- 15 Apr 2020 09:23 PM
- DD_MMM_YYYY-TIME
- 19 Mar, 9:32 AM
- DD_MMM-TIME
- Mon, 19 Mar
- DAY_DD_MM
- Apr 20
- MMM_YY
- 12 31
- MM_DD
- 01 Jan
- DD_MMM
- 04 2020
- MM_YYYY
- Sep 07 2020
- MMM_DD_YYYY
- 07-Sep-20
- DD_MMM_YY_HYPHEN
- 07/09/2020
- DD_MM_YYYY_SLASH
See also
- Changing the date and time settings
- Date and time formats for the en-IN locale
- Date and time formats for the ja-JP locale
- Date and time formats for the vi-VN locale