Lot of time we struggled when formatting date and time in Salesforce, the below table helps you the Syntax for formatting Date and Time.
Date
Field Symbols
|
|||
Symbol
|
Meaning
|
Example(s)
|
|
G
|
era designator
|
G, GG, or GGG
GGGG GGGGG |
AD
Anno Domini A |
y
|
year
|
yy
y or yyyy |
96
1996 |
Y
|
year of "Week of Year"
|
Y
|
1997
|
u
|
extended year
|
u
|
4601
|
U
|
cyclic year name, as in Chinese lunar calendar
|
U
|
甲子
|
Q
|
quarter
|
Q or QQ
QQQ QQQQ |
02
Q2 2nd quarter |
q
|
Stand Alone quarter
|
q or qq
qqq qqqq |
02
Q2 2nd quarter |
M
|
month in year
|
M or MM
MMM MMMM MMMMM |
09
Sept September S |
L
|
Stand Alone month in year
|
L or LL
LLL LLLL LLLLL |
09
Sept September S |
w
|
week of year
|
w or ww
|
27
|
W
|
week of month
|
W
|
2
|
d
|
day in month
|
d
dd |
2
02 |
D
|
day of year
|
D
|
189
|
F
|
day of week in month
|
F
|
2 (2nd Wed in July)
|
g
|
modified julian day
|
g
|
2451334
|
E
|
day of week
|
E, EE, or EEE
EEEE EEEEE EEEEEE |
Tues
Tuesday T Tu |
e
|
local day of week
example: if Monday is 1st day, Tuesday is 2nd ) |
e or ee
eee eeee eeeee eeeeee |
2
Tues Tuesday T Tu |
c
|
Stand Alone local day of week
|
c or cc
ccc cccc ccccc cccccc |
2
Tues Tuesday T Tu |
a
|
am/pm marker
|
a
|
pm
|
h
|
hour in am/pm (1~12)
|
h
hh |
7
07 |
H
|
hour in day (0~23)
|
H
HH |
0
00 |
k
|
hour in day (1~24)
|
k
kk |
24
24 |
K
|
hour in am/pm (0~11)
|
K
KK |
0
00 |
m
|
minute in hour
|
m
mm |
4
04 |
s
|
second in minute
|
s
ss |
5
05 |
S
|
millisecond (maximum of 3 significant digits);
for S or SS, truncates to the number of letters for SSSS or longer, fills additional places with 0 |
S
SS SSS SSSS |
2
23 235 2350 |
A
|
milliseconds in day
|
A
|
61201235
|
z
|
Time Zone: specific non-location
|
z, zz, or zzz
zzzz |
PDT
Pacific Daylight Time |
Z
|
Time Zone: ISO8601 basic hms? / RFC 822
Time Zone: long localized GMT (=OOOO) TIme Zone: ISO8601 extended hms? (=XXXXX) |
Z, ZZ, or ZZZ
ZZZZ ZZZZZ |
-0800
GMT-08:00 -08:00, -07:52:58, Z |
O
|
Time Zone: short localized GMT
Time Zone: long localized GMT (=ZZZZ) |
O
OOOO |
GMT-8
GMT-08:00 |
v
|
Time Zone: generic non-location
(falls back first to VVVV) |
v
vvvv |
PT
Pacific Time or Los Angeles Time |
V
|
Time Zone: short time zone ID
Time Zone: long time zone ID Time Zone: time zone exemplar city Time Zone: generic location (falls back to OOOO) |
V
VV VVV VVVV |
uslax
America/Los_Angeles Los Angeles Los Angeles Time |
X
|
Time Zone: ISO8601 basic hm?, with Z for 0
Time Zone: ISO8601 basic hm, with Z Time Zone: ISO8601 extended hm, with Z Time Zone: ISO8601 basic hms?, with Z Time Zone: ISO8601 extended hms?, with Z |
X
XX XXX XXXX XXXXX |
-08, +0530, Z
-0800, Z -08:00, Z -0800, -075258, Z -08:00, -07:52:58, Z |
z
|
Time Zone: ISO8601 basic hm?, without Z for 0
Time Zone: ISO8601 basic hm, without Z Time Zone: ISO8601 extended hm, without Z Time Zone: ISO8601 basic hms?, without Z Time Zone: ISO8601 extended hms?, without Z |
x
xx xxx xxxx xxxxx |
-08, +0530
-0800 -08:00 -0800, -075258 -08:00, -07:52:58 |
'
|
escape for text
|
'
|
(nothing)
|
' '
|
two single quotes produce one
|
' '
|
'
|
Examples:
|
Format Pattern
|
Result
|
yyyy.MM.dd G 'at' HH:mm:ss zzz
|
1996.07.10 AD at 15:08:56 PDT
|
EEE, MMM d, ''yy
|
Wed, July 10, '96
|
h:mm a
|
12:08 PM
|
hh 'o''clock' a, zzzz
|
12 o'clock PM, Pacific Daylight Time
|
K:mm a, z
|
0:00 PM, PST
|
yyyyy.MMMM.dd GGG hh:mm aaa
|
01996.July.10 AD 12:08 PM
|
No comments:
Post a Comment