| TABLE 1: T-SQL's CONVERT Function Datetime Display Masks |
| Show YY in year |
Show YYYY in year |
Description |
Display Format |
| |
0 or 100* |
Default |
mon dd yyyy hh:miAM (or PM) |
| 1 |
101 |
US |
mm/dd/yy |
| 2 |
102 |
ANSI |
yy.mm.dd |
| 3 |
103 |
British and French |
dd/mm/yy |
| 4 |
104 |
German |
dd.mm.yy |
| 5 |
105 |
Italian |
dd-mm-yy |
| 6 |
106 |
|
dd mon yy |
| 7 |
107 |
|
mon dd, yy |
| 8 |
108 |
|
hh:mm:ss |
| |
9 or 109* |
Default milliseconds |
mon dd yyyy hh:mi:ss:mmmAM (or PM) |
| 10 |
110 |
US |
mm-dd-yy |
| 11 |
111 |
Japan |
yy/mm/dd |
| 12 |
112 |
International Standards Organization (ISO) |
yymmdd |
| |
13 or 113* |
Europe default milliseconds |
dd mon yyyy hh:mm:ss:mmm(24h) |
| 14 |
114 |
|
hh:mi:ss:mmm(24h) |
| * The default values (style 0 or 100, 9 or 109, and 13 or 113) always return to the century (yyyy) |