major date function specifiers

Question 1

d

Answer 1

Day of the month, two digits, with leading zeros. 01 to 31

Question 2

D

Answer 2

Day of the week, three letters. Mon to Sun

Question 3

j

Answer 3

Day of the month, no leading zeros. 1 to 31

Question 4

l

Answer 4

Day of week, full names. Sunday to Saturday

Question 5

N

Answer 5

Day of week, numeric, Monday to Sunday. 1 to 7

Question 6

S

Answer 6

Suffix for day of month (useful with specifier j) st, nd, rd, or th

Question 7

w

Answer 7

Day of week, numeric, Sunday to Saturday. 0 to 6

Question 8

z

Answer 8

Day of year. 0 to 365

Question 9

W

Answer 9

Week number or year. 01 to 52

Question 10

F

Answer 10

Month name. January to December

Question 11

m

Answer 11

Month number with leading zeros. 01 to 12

Question 12

M

Answer 12

Month name, three letters. Jan to Dec

Question 13

n

Answer 13

Month number, no leading zeros 1 to 12

Question 14

t

Answer 14

Number of days in given month. 28 to 31

Question 15

L

Answer 15

Leap year. 1 = Yes, 0 = No

Question 16

y

Answer 16

Year, 2 digits. 00 to 99

Question 17

Y

Answer 17

Year, 4 digits 0000 to 9999

Question 18

a

Answer 18

Before or after midday, lowercase. am or pm

Question 19

A

Answer 19

Before or after midday, uppercase. AM or PM

Question 20

g

Answer 20

Hour of day, 12-hour format, no leading zeros. 1 to 12

Question 21

G

Answer 21

Hour of day, 24-hour format, no leading zeros. 00 to 23

Question 22

h

Answer 22

Hour of day, 12-hour format, with leading zeros. 01 to 12

Question 23

H

Answer 23

Hour of day, 24-hour format, with leading zeros. 00 to 23

Question 24

i

Answer 24

Minutes, with leading zeros. 00 to 59

Question 25

s

Answer 25

Seconds, with leading zeros 00 to 59