Transfer it when you use the LIKE query for the DateTime or SmallDataTime type. Such as:
SELECT A, B from Awhere Convert (nchar (50), A, 120) Like '% 2004-10-13%'
Default replacement, as follows
With a century (YY) Belt Century (YYY) standard input / output ** - 0 or 100 (*) defaults MON DD YYYY HH: MIAM (or PM) 1101 United States mm / dd / yyyy2102ansiyy.mm.dd3103 United Kingdom / French DD / MM / YY4104 German DD.MM.YY5105 Italy DD-MM-YY6106-DD MON YY7107-MON DD, YY8108-HH: MM: SS-9 or 109 (*) Default milliseconds MON DD YYYY HH: Mi : SS: MMMAM (or PM) 10110 US MM-DD-YY11111 Japan YY / MM / DD12112IyMMDD-13 or 113 (*) European default value milliseconds DD MON YYYY HH: mm: SS: MMM (24h) 14114-hh: MI: SS: MMM (24H) -20 or 120 (*) ODBC Specification YYYY-MM-DD HH: MM: SS [.FFF] -21 or 121 (*) ODBC Specification (with milliseconds) YYYY-MM-DD HH : mm: ss [.fff] -126 (***) ISO8601YYYY-MM-DD THH: mm: SS: MMM (excluding space) -130 * Kuwait DD MON YYYYY HH: MI: SS: MMMAM-131 * Kuwait DD / MM / YY HH: MI: SS: MMMAM
