= Tutoriales =
EditarTabla para tener en cuenta explicitamente el formato de las fechas en las consultas al sql server.
Ejemplo de consulta:
SELECT FROM tabla WHERE
(fecha BETWEEN
CONVERT(DATETIME, '30/12/2007 0:00:00', 103) AND
CONVERT(DATETIME, '31/12/2007 23:59:59', 103))
El 103 indica que la fecha va en formato frances dd/mm/yyyy (Versus Español)
EditarFormatos mas habituales para convertir strings en fechas.
La primera columna es el codigo para el mandato CONVERT
| CODIGO | DESCRIPCION | FORMATO |
| or 100 | Default. Equivalent to not specifying a style code. mon dd yyyy hh:mmAM ||Sep 8 2007 9:00PM |
| 1 | USA date. mm/dd/yy | 12/31/07 |
| 2 | ANSI date. yy.mm.dd | 07/12/31 |
| 3 | UK / French date. dd/mm/yy | 31/12/07 |
| 4 | German date. dd.mm.yy | 31.12.07 |
| 5 | Italian date. dd-mm-yy | 31-12-07 |
| 6 | Abbreviated month. dd mmm yy | 31 Sep 07 |
| 7 | Abbreviated month. mmm dd, yy | Sep 31, 07 |
| 8 | or 108 24 hour time. HH:mm:ss | 21:00:00 |
| 9 | or 109 Default formatting with seconds and milliseconds appended. mon dd yyyy hh:mm:ss:fffAM | Sep 8 2007 9:00:00:000PM |
| 10 | USA date with hyphen separators. mm-dd-yy | 12-31-07 |
| 11 | Japanese date. yy/mm/dd | 07/12/31 |
| 12 | ISO date. yymmdd | 071231 |
| 13 | or 113 European default with seconds and milliseconds. dd mon yyyy HH:mm:ss:fff | 31 Sep 2007 21:00:00:000 |
| 14 | or 114 24 hour time with milliseconds. HH:mm:ss:fff | 21:00:00:000 |
| 20 | or 120 ODBC canonical date and time. yyyy-mm-dd HH:mm:ss | 2007-12-31 21:00:00 |
| 21 | or 121 ODBC canonical date and time with milliseconds. yyyy-mm-dd HH:mm:ss.fff | 2007-12-31 21:00:00.000 |
| 101 | USA date with century. mm/dd/yyyy | 12/31/2007 |
| 102 | ANSI date with century. yyyy.mm.dd | 2007/12/31 |
| 103 | UK / French date with century. dd/mm/yyyy | 31/12/2007 |
| 104 | German date with century. dd.mm.yyyy | 31.12.2007 |
| 105 | Italian date with century. dd-mm-yyyy | 31-12-2007 |
| 106 | Abbreviated month with century. dd mmm yyyy | 31 Sep 2007 |
| 107 | Abbreviated month with century. mmm dd, yyyy | Sep 31, 2007 |
| 110 | USA date with hyphen separators and century. mm-dd-yyyy | 12-31-2007 |
| 111 | Japanese date with century. yyyy/mm/dd | 2007/12/31 |
| 112 | ISO date with century. yymmdd | 20071231 |
| 126 | ISO8601, for use in XML. yyy-mm-ddThh:mm:ss | 2007-12-31T21:00:00 |