The table below provides examples of date/time formats to help you select or enter the appropriate format.
| Date/Time Format | Example 1 | Example 2 |
| April 1st, 2018
3:20:15 pm PDT |
October 21st, 2018
11:53:12 am PDT |
|
|
YYYY-MM-DDTHH:mm:ssZ |
2018-04-01T15:20:15-07:00 |
2018-10-21T11:53:12-07:00 |
|
YYYY-MM-DDTHH:mm:ss |
2018-04-01T15:20:15 |
2018-10-21T11:53:12 |
|
YYYY-MM-DDTHH:mm:ss[Z] |
2018-04-01T15:20:15Z |
2018-10-21T11:53:12Z |
|
YYYY-MM-DDTHH:mm:ss.SSSZZ |
2018-04-01T15:20:15.000-0700 |
2018-10-21T11:53:12.000-0700 |
|
YYYY-MM-DDTHH:mm:ss.SSSSZ |
2018-04-01T15:20:15.000-07:00 |
2018-10-21T11:53:12.000-07:00 |
|
YYYY-MM-DD HH:mm:ss |
2018-04-01 15:20:15 |
2018-10-21 11:53:12 |
|
X |
1522621215 |
1540147992 |
|
M/D/YYYY |
4/1/2018 |
10/21/2018 |
|
YYMMDD |
180401 |
181021 |
|
MMDDYY |
040118 |
102118 |
|
DDMMYY |
010418 |
211018 |
|
DDMMYYYY |
01042018 |
21102018 |
|
DDMMYYYY hh:mm |
01042018 03:20 |
21102018 11:53 |
|
DDMMYYYY hh:mm:ss |
01042018 03:20:15 |
21102018 11:53:12 |
|
MM/DD/YYYY hh:mm:ss SS |
04/01/2018 03:20:15 00 |
10/21/2018 11:53:12 00 |
|
MM/DD/YYYY hh:mm A |
04/01/2018 03:20 PM |
10/21/2018 11:53 AM |
|
MM/DD/YYYY hh:mm:ss A |
04/01/2018 03:20:15 PM |
10/21/2018 11:53:12 AM |
|
DD/MM/YYYY |
01/04/2018 |
21/10/2018 |
|
DD/MM/YYYY hh:mm |
01/04/2018 03:20 |
21/10/2018 11:53 |
|
DD/MM/YYYY hh:mm:ss SS |
01/04/2018 03:20:15 00 |
21/10/2018 11:53:12 00 |
|
DD-MMM-YYYY hh:mm A |
01-Apr-2018 03:20 PM |
21-Oct-2018 11:53 AM |
|
DD/MM/YYYY hh:mm:ss A |
01/04/2018 03:20:15 PM |
21/10/2018 11:53:12 AM |
|
YYYY/MM/DD |
2018/04/01 |
2018/10/21 |
|
YYYY/MM/DD hh:mm |
2018/04/01 03:20 |
2018/10/21 11:53 |
|
YYYY/MM/DD hh:mm:ss |
2018/04/01 03:20:15 |
2018/10/21 11:53:12 |
|
YYYY/MM/DD hh:mm:ss SS |
2018/04/01 03:20:15 00 |
2018/10/21 11:53:12 00 |
|
YYYY/MM/DD hh:mm:ss A |
2018/04/01 03:20:15 PM |
2018/10/21 11:53:12 AM |
|
YYYY/MM/DD hh:mm A |
2018/04/01 03:20 PM |
2018/10/21 11:53 AM |
|
DD-MMM-YYYY |
01-Apr-2018 |
21-Oct-2018 |
|
MMM DD YYYY hh:mm A |
Apr 01 2018 03:20 PM |
Oct 21 2018 11:53 AM |
|
MMMM DD YYYY hh:mm:ss A |
April 01 2018 03:20:15 PM |
October 21 2018 11:53:12 AM |
|
DD.MM.YYYY |
01.04.2018 |
21.10.2018 |
|
MM.DD.YYYY |
04.01.2018 |
10.21.2018 |
|
hh:mm:ss.SSS Z |
03:20:15.000 -07:00 |
11:53:12.000 -07:00 |
|
hh:mm:ss Z |
03:20:15 -07:00 |
11:53:12 -07:00 |
|
hh:mm:ss A Z |
03:20:15 PM -07:00 |
11:53:12 AM -07:00 |
|
hh:mm:ss A |
03:20:15 PM |
11:53:12 AM |
|
hh:mm:ssA |
03:20:15PM |
11:53:12AM |
|
hh:mm:ss.SSA |
03:20:15.00PM |
11:53:12.00AM |
|
hh:mm:ss.SS |
03:20:15.00 |
11:53:12.00 |
|
hh:mm:ss |
03:20:15 |
11:53:12 |