Codificação de datas no sql server
450 palavras
2 páginas
Supondo CURRENT_TIMESTAMP retornando o dia 22 de fevereiro de 2006 as 16 horas 26 minutos e 8 segundos. 0 | Feb 22 2006 4:26PM | CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) | 1 | 02/22/06 | CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1) | 2 | 06.02.22 | CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2) | 3 | 22/02/06 | CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3) | 4 | 22.02.06 | CONVERT(CHAR(8), CURRENT_TIMESTAMP, 4) | 5 | 22-02-06 | CONVERT(CHAR(8), CURRENT_TIMESTAMP, 5) | 6 | 22 Feb 06 | CONVERT(CHAR(9), CURRENT_TIMESTAMP, 6) | 7 | Feb 22, 06 | CONVERT(CHAR(10), CURRENT_TIMESTAMP, 7) | 8 | 16:26:08 | CONVERT(CHAR(8), CURRENT_TIMESTAMP, 8 ) | 9 | Feb 22 2006 4:26:08:020PM | CONVERT(CHAR(26), CURRENT_TIMESTAMP, 9) | 10 | 02-22-06 | CONVERT(CHAR(8), CURRENT_TIMESTAMP, 10) | 11 | 06/02/22 | CONVERT(CHAR(8), CURRENT_TIMESTAMP, 11) | 12 | 060222 | CONVERT(CHAR(6), CURRENT_TIMESTAMP, 12) | 13 | 22 Feb 2006 16:26:08:020 | CONVERT(CHAR(24), CURRENT_TIMESTAMP, 13) | 14 | 16:26:08:037 | CONVERT(CHAR(12), CURRENT_TIMESTAMP, 14) | 20 | 2006-02-22 16:26:08 | CONVERT(CHAR(19), CURRENT_TIMESTAMP, 20) | 21 | 2006-02-22 16:26:08.037 | CONVERT(CHAR(23), CURRENT_TIMESTAMP, 21) | 22 | 02/22/06 4:26:08 PM | CONVERT(CHAR(20), CURRENT_TIMESTAMP, 22) | 23 | 2006-02-22 | CONVERT(CHAR(10), CURRENT_TIMESTAMP, 23) | 24 | 16:26:08 | CONVERT(CHAR(8), CURRENT_TIMESTAMP, 24) | 25 | 2006-02-22 16:26:08.037 | CONVERT(CHAR(23), CURRENT_TIMESTAMP, 25) | 100 | Feb 22 2006 4:26PM | CONVERT(CHAR(19), CURRENT_TIMESTAMP, 100) | 101 | 02/22/2006 | CONVERT(CHAR(10), CURRENT_TIMESTAMP, 101) | 102 | 2006.02.22 | CONVERT(CHAR(10), CURRENT_TIMESTAMP, 102) | 103 | 22/02/2006 | CONVERT(CHAR(10), CURRENT_TIMESTAMP, 103) | 104 | 22.02.2006 | CONVERT(CHAR(10), CURRENT_TIMESTAMP, 104) | 105 | 22-02-2006 | CONVERT(CHAR(10), CURRENT_TIMESTAMP, 105) | 106 | 22 Feb 2006 | CONVERT(CHAR(11), CURRENT_TIMESTAMP, 106) | 107 | Feb 22, 2006 | CONVERT(CHAR(12), CURRENT_TIMESTAMP, 107) | 108 |