Description
NumberFormat values for Date data types
Values
Name |
Description |
---|---|
DayMonthYear |
d-mmm-yyyy;@ For example, 2-Feb-08.) |
DayOfWeekMonthDayYear |
dddd, mmmm dd, yyyy (For example, Saturday, February 2, 2008.) |
FullTextMonthDayYear |
mmmm d, yyyy;@ (For example, February 2, 2008.) |
FullTextMonthYear |
mmmm-yy;@ (For example, February-08.) |
MonthDay |
m/d;@ |
MonthDayYear |
m/d/yy;@ |
MonthDayYearHourMinute12 |
m/d/yy h:mm AM/PM;@ (For example, 2/2/08 12:00 AM) |
MonthDayYearHourMinute24 |
m/d/yy h:mm;@ (For example, 2/2/08 0:00) |
MonthDayYearPreserveLeadingZero |
mm/dd/yy;@ |
MonthSingleLetter |
mmmmm;@ (For example, D for December or S for Septmeber.) |
MonthSingleLetterYear |
mmmmm-yy;@ (For example, F-08 for February 2008.) |
TextDayMonth |
d-mmm;@ |
TextDayMonthYear |
d-mmm-yy;@ |
TextDayMonthYearPreserveLeadingZero |
dd-mmm-yy;@ |
TextMonthYear |
mmm-yy;@ (For example, Feb-08.) |