Use the following table to specify date formats. For further information on valid date formats used in this step, view the Date Formatting Tablearrow-up-right.
G
Era designator
Text
AD
y
Year
1996 or 96
1996
96
M
Month in year
Month
July, Jul, or 07
July
Jul
07
w
Week in year
Number
27
W
Week in Month
2
D
Day in year
189
d
Day in month
10
F
Day of week in month
E
Day in week
Tuesday or Tue
Tuesday
Tue
a
am/pm marker
PM
H
Hour in day (0-23)
Number 0
n/a
k
Hour in day (1-24)
Number 24
K
Hour in am/pm (0-11)
h
Hour in am/pm (1-12)
Number 12
m
Minute in hour
Number 30
s
Second in minute
Number 55
S
Millisecond
Number 978
z
Time zone
General time zone
Pacific Standard Time, PST, or GMT-08:00
Pacific Standard Time
PST
GMT-08:00
Z
RFC 822 time zone
-0800
Last updated 8 months ago
Was this helpful?