Skip to end of metadata
Go to start of metadata

The following format characters can be used to represent custom Date and Time patterns where applicable. 

format Character

Description

Example Returned Values

Day

---

---

d

Day of the month, 2 digits with
leading zeros

01 to 31

D

A textual representation of a day
 with Three Letters

Mon through Sun

j

Day of the month without leading
zeros

1 to 31

l (lowercase L)

A full textual representation of the
day of the week.

Sunday through Saturday

S

English ordinal suffix for the day 
of the month, 2 characters

st, nd, rd or th. Works well 
with j

z

The day of the year (starting from
0).

0 through 365

Month

---

---

F

A full textual representation of a
month, such as January or March

 January through December

m

Numeric representation of a month,
with leading zeros 01 through 12

01 through 12

M

A short textual representation of a
month, three letters

Jan through Dec

n

Numeric representation of a month,
 without leading zeros

1 through 12

Year

---

---

Y

A full numeric representation of a year, 4 digits

E.g. 1999 or 2003

y

A two digit representation of a year

E.g. 99 or 03

Time

---

---

a

Lowercase Ante meridiem and Post meridiem

am or pm

A

Uppercase Ante meridiem and Post meridiem

AM or PM

g

12-hour format of an hour without leading zeros

1 through 12

G

24-hour format of an hour without leading zeros

0 through 23

h

12-hour format of an hour with leading zeros

01 through 12

H

24-hour format of an hour with leading zeros

00 through 23

i

Minutes with leading zeros

00 to 59

s

Seconds, with leading zeros

00 through 59

u

Microseconds

E.g. 123456

Full Date/Time

---

---

R

RFC 2822 formatted date.

E.g. Thu, 21 Dec
2000 16:01:07 +0200

Labels
  • No labels