Mega Code Archive
Values for the style argument of the CONVERT function when you convert a datetime expression to a character express
<![CDATA[
Style Number Style Number Output Type Style
without Century (yy) with Century (yyyy)
- 0 or 100 Default mon dd yyyy hh:miAM (or PM)
1 101 USA mm/dd/yyyy
2 102 ANSI yyyy.mm.dd
3 103 British/French dd/mm/yyyy
4 104 German dd.mm.yyyy
5 105 Italian dd-mm-yyyy
6 106 - dd mon yyyy
7 107 - mon dd, yyyy
- 8 or 108 - hh:mm:ss
- 9 or 109 Default + mon dd yyyy hh:mi:ss:mmmAM
milliseconds (or PM)
10 110 USA mm-dd-yy
11 111 JAPAN yy/mm/dd
12 112 ISO yymmdd
- 13 or 113 Europe default + dd mon yyyy hh:mi:ss:mmm (24h)
milliseconds
14 114 - hh:mi:ss:mmm (24h)
20 or 120 ODBC canonical yyyy-mm-dd hh:mi:ss(24h)
21 or 121 ODBC canonical + yyyy-mm-dd hh:mi:ss.mmm(24h)
milliseconds
]]>