Symbol |
Description |
: (colon) |
time separator. |
/ |
dates separator. |
c |
same as the General Date predefined format. |
d |
Day of the month in one or two digits, whichever is necessary ( 1 to 31). |
dd |
Day of the month in two numerical digits (01 to 31). |
ddd |
The first three letters of the day of the week (Sun to Sat). |
dddd |
Full name of the day of the week (Sunday to Saturday). |
ddddd |
same as the Short Date predefined format. |
dddddd |
same as the Long Date predefined format. |
w |
Day of the week (1 to 7). |
www |
Week of the year (1 to 53). |
m |
The month of the year in one or two numerical digits, whichever necessary ( 1 to 12). |
mm |
Month of the year in two numerical digits (01 to 12). |
mmm |
First three letters of the month (Jan to Dec). |
mmmm |
Full name of the month (January to December). |
q |
Date shown as a quarter of the year (1 to 4). |
y |
Number of the day of the year (1 - 366). |
yy |
Last two digits of the year (01 -99). |
yyyy |
Complete year (0100 to 9999). |
h |
Hour in one or two digits, whichever necessary (0 to 23). |
hh |
Hour in two digits (00 to 23). |
n |
Minutes in one or two digits, whichever necessary (0 to 59). |
nn |
Minutes in two digits (00 to 59). |
s |
Seconds in one or two digits, whichever necessary (0 to 59). |
ss |
Seconds in two digits (00 to 59). |
ttttt |
same as the Long Hour predefined format. |
AM/PM |
12 Hour clock with the uppercase letters AM or PM, whichever appropriate. |
am/pm |
12 Hour clock with the lowercase letters am or pm, whichever appropriate. |
A/P |
12 Hour clock with uppercase letters A or P, whichever appropriate. |
a/p |
12 Hour clock with the lowercase letters a or p, whichever appropriate. |
AMPM |
12 Hour watch with the appropriate morning/afternoon indicater. |