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.