TABLE 1: CONVERT Function Codes
YY YYYY Standard Format
-0 or 100*Defaultmon dd yyyy
hh:miAM (or PM)
1101USAmm/dd/yy
2102ANSIyy.mm.dd
3103British/Frenchdd/mm/yy
4104Germandd.mm.yy
5105Italiandd-mm-yy
6106- dd mon yy
7107 - mon dd, yy
8108 - hh:mm:ss
-9 or 109* Default + Mon dd yyyy
milliseconds hh:mi:ss:mmmAM (or PM)
10110USAmm-dd-yy
11111JAPANyy/mm/dd
12112ISOyymmdd
-13 or 113*Europe Default + dd mon yyyy
millisecondshh:mm:ss:mmm(24h)
14114-hh:mi:ss:mmm(24h)
-20 or 120*ODBC canonicalyyyy-mm-dd hh:mi:ss(24h)
- 21 or 121* ODBC canonical
(with milliseconds)
yyyy-mm-dd
hh:mi:ss.mmm(24h)
* The default values (style 0 or 100, 9 or 109, 13 or 113, 20 or 120, and 21 or 121) always return the century (yyyy).