SQL Server – Conversiones de Tipo de Fecha
Written by lopezatienza on 21/05/2009 – 13:45 -Aquí os dejo una tabla de Conversiones de tipos de Fecha en Sql Server 2005:
Estas consultas se han realizado el día 21 de Mayo de 2009 aproximadamente a las 13:20:00.
SELECT CONVERT(VARCHAR(11), GETDATE(), 1) |
05/21/09 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 2) |
09.05.21 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 3) |
21/05/09 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 4) |
21.05.09 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 5) |
21-05-09 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 6) |
21 May 09 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 7) |
May 21, 09 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 8) |
13:20:05 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 9) |
May 21 2009 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 10) |
05-21-09 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 11) |
09/05/21 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 12) |
090521 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 13) |
21 May 2009 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 14) |
13:20:59:56 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 20) |
2009-05-21 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 21) |
2009-05-21 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 22) |
05/21/09 1 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 23) |
2009-05-21 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 24) |
13:22:36 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 25) |
2009-05-21 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 100) |
May 21 2009 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 101) |
05/21/2009 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 102) |
2009.05.21 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 103) |
21/05/2009 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 104) |
21.05.2009 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 105) |
21-05-2009 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 106) |
21 May 2009 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 107) |
May 21, 200 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 108) |
13:27:27 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 109) |
May 21 2009 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 110) |
05-21-2009 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 111) |
2009/05/21 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 112) |
20090521 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 113) |
21 May 2009 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 114) |
13:28:28:48 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 120) |
2009-05-21 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 121) |
2009-05-21 |
SELECT CONVERT(VARCHAR(11), GETDATE(), 126) |
2009-05-21T |
SELECT CONVERT(VARCHAR(11), GETDATE(), 127) |
2009-05-21T |
SELECT CONVERT(VARCHAR(11), GETDATE(), 130) |
27 ????? ?? |
SELECT CONVERT(VARCHAR(11), GETDATE(), 131) |
27/05/1430 |
Tags: SQL Server
Posted in SQL Server | No Comments »