Articles in this section

Date and time format reference

The table below provides examples of date/time formats to help you select or enter the appropriate format.

Date/Time FormatExample 1Example 2

April 1st, 2018

3:20:15 pm PDT

October 21st, 2018

11:53:12 am PDT

YYYY-MM-DDTHH:mm:ssZ2018-04-01T15:20:15-07:002018-10-21T11:53:12-07:00
YYYY-MM-DDTHH:mm:ss2018-04-01T15:20:152018-10-21T11:53:12
YYYY-MM-DDTHH:mm:ss[Z]2018-04-01T15:20:15Z2018-10-21T11:53:12Z
YYYY-MM-DDTHH:mm:ss.SSSZZ2018-04-01T15:20:15.000-07002018-10-21T11:53:12.000-0700
YYYY-MM-DDTHH:mm:ss.SSSSZ2018-04-01T15:20:15.000-07:002018-10-21T11:53:12.000-07:00
YYYY-MM-DD HH:mm:ss2018-04-01 15:20:152018-10-21 11:53:12
X15226212151540147992
M/D/YYYY4/1/201810/21/2018
YYMMDD180401181021
MMDDYY040118102118
DDMMYY010418211018
DDMMYYYY0104201821102018
DDMMYYYY hh:mm01042018 03:2021102018 11:53
DDMMYYYY hh:mm:ss01042018 03:20:1521102018 11:53:12
MM/DD/YYYY hh:mm:ss SS04/01/2018 03:20:15 0010/21/2018 11:53:12 00
MM/DD/YYYY hh:mm A04/01/2018 03:20 PM10/21/2018 11:53 AM
MM/DD/YYYY hh:mm:ss A04/01/2018 03:20:15 PM10/21/2018 11:53:12 AM
DD/MM/YYYY01/04/201821/10/2018
DD/MM/YYYY hh:mm01/04/2018 03:2021/10/2018 11:53
DD/MM/YYYY hh:mm:ss SS01/04/2018 03:20:15 0021/10/2018 11:53:12 00
DD-MMM-YYYY hh:mm A01-Apr-2018 03:20 PM21-Oct-2018 11:53 AM
DD/MM/YYYY hh:mm:ss A01/04/2018 03:20:15 PM21/10/2018 11:53:12 AM
YYYY/MM/DD2018/04/012018/10/21
YYYY/MM/DD hh:mm2018/04/01 03:202018/10/21 11:53
YYYY/MM/DD hh:mm:ss2018/04/01 03:20:152018/10/21 11:53:12
YYYY/MM/DD hh:mm:ss SS2018/04/01 03:20:15 002018/10/21 11:53:12 00
YYYY/MM/DD hh:mm:ss A2018/04/01 03:20:15 PM2018/10/21 11:53:12 AM
YYYY/MM/DD hh:mm A2018/04/01 03:20 PM2018/10/21 11:53 AM
DD-MMM-YYYY01-Apr-201821-Oct-2018
MMM DD YYYY hh:mm AApr 01 2018 03:20 PMOct 21 2018 11:53 AM
MMMM DD YYYY hh:mm:ss AApril 01 2018 03:20:15 PMOctober 21 2018 11:53:12 AM
DD.MM.YYYY01.04.201821.10.2018
MM.DD.YYYY04.01.201810.21.2018
hh:mm:ss.SSS Z03:20:15.000 -07:0011:53:12.000 -07:00
hh:mm:ss Z03:20:15 -07:0011:53:12 -07:00
hh:mm:ss A Z03:20:15 PM -07:0011:53:12 AM -07:00
hh:mm:ss A03:20:15 PM11:53:12 AM
hh:mm:ssA03:20:15PM11:53:12AM
hh:mm:ss.SSA03:20:15.00PM11:53:12.00AM
hh:mm:ss.SS03:20:15.0011:53:12.00
hh:mm:ss03:20:1511:53:12