Skip to content

Date-time display examples

Feedback

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.

Display Format Code Description
01:43 pm HH_MM_A 12-hour clock with AM/PM
01:43 PM HH_MM_CAPA 12-hour clock with uppercase AM/PM
1:43 pm H_MM_A 12-hour clock with AM/PM (single digit hour)
1:43 PM H_MM_CAPA 12-hour clock with uppercase AM/PM (single digit hour)
13:44 HH_MM 24-hour clock
9:44 H_MM 24-hour clock (single digit hour)
13:45:12 HH_MM_SS Time with seconds
13:45:44 PM HH_MM_SS_A Time with seconds and AM/PM
8:45:12 H_MM_SS Time with seconds (single digit hour)
8:45:44 PM H_MM_SS_A Time with seconds and AM/PM (single digit hour)
18:42:59 JA_TIME_HH_MM_SS Japanese time format with seconds
18:45 JA_TIME_HH_MM Japanese time format
01時47分 午後 JA_TIME_HH_MM_A Japanese time format with AM/PM (kana characters)
午後01時47分 JA_TIME_SYM_HH_MM Japanese time format with AM/PM (symbols)
2020年9月7日 JA_DATE Japanese date format (year, month, day)
2020年 09月 JA_DATE_YYYY_MM Japanese date format (year, 2-digit month)
09月07日 JA_MMM_DD Japanese date format (month abbreviation, day)
15 Apr 2020 DD_MMM_YYYY Day, month abbreviation, year
2020 09 YYYY_MM Year, 2-digit month
Mon, 19 Mar, 9:32 AM DAY_DD_MMM-TIME Day of week, day, month abbreviation, time
15 Apr 2020 09:23 PM DD_MMM_YYYY-TIME Day, month abbreviation, year, time
19 Mar, 9:32 AM DD_MMM-TIME Day, month abbreviation, time
Mon, 19 Mar DAY_DD_MM Day of week, day, 2-digit month
Apr 20 MMM_YY Month abbreviation, 2-digit year
12 31 MM_DD 2-digit month, day
01 Jan DD_MMM Day, month abbreviation
04 2020 MM_YYYY 2-digit month, year
Sep 07 2020 MMM_DD_YYYY Month abbreviation, day, year
07-Sep-20 DD_MMM_YY_HYPHEN Day, month abbreviation, 2-digit year (hyphen separator)
07/09/2020 DD_MM_YYYY_SLASH Day, 2-digit month, year (slash separator)

See also

Did this page help? No help at allYes, totally!
Back to top