Formatos De Datas No SQL SERVER
Data Formatos Standard | Data Formatos prolongado | |||||
Formato de data | Instrução SQL | Saída da amostra | Formato de data | Instrução SQL | Saída da amostra | |
Seg DD YYYY 1 | SELECT CONVERT (VARCHAR (20), GETDATE (), 100) | Janeiro 2005 01:29 1 1 | YY-MM-DD | SELECT SUBSTRING (CONVERT (VARCHAR (10), GETDATE (), 120), 3, 8) AS [AA-MM-DD] | 99-01-24 | |
HH: MIAM (ou PM) | SELECT REPLACE (CONVERT (VARCHAR (8) GETDATE (), 11), '/', '-') AS [AA-MM-DD] | |||||
DD / MM / YY | SELECT CONVERT (VARCHAR (8) GETDATE (), 1) AS [DD / MM / YY] | 11/23/98 | AAAA-MM-DD | SELECT CONVERT (VARCHAR (10), GETDATE (), 120) AS [AAAA-MM-DD] | ###### | |
DD / MM / AAAA | SELECT CONVERT (VARCHAR (10), GETDATE (), 101) AS [DD / MM / AAAA] | 11/23/1998 | SELECT REPLACE (CONVERT (VARCHAR (10), GETDATE (), 111), '/', '-') AS [AAAA-MM-DD] | |||
YY.MM.DD | SELECT CONVERT (VARCHAR (8) GETDATE (), 2) AS [YY.MM.DD] | 72.01.01 | MM / AA | SELECT RIGHT (CONVERT (VARCHAR (8) GETDATE (), 3), 5) AS [MM / AA] | ago/99 | |
Yyyy.mm.dd | SELECT CONVERT (VARCHAR (10), GETDATE (), 102) AS [yyyy.mm.dd] | 1972.01.01 | SELECT SUBSTRING (CONVERT (VARCHAR (8) GETDATE (), 3), 4, 5) AS [MM / AA] | |||
DD / MM / AA | SELECT CONVERT (VARCHAR (8) GETDATE (), 3) AS [DD / MM / AA] | 19/02/1972 | MM / AAAA | SELECT RIGHT (CONVERT (GETDATE VARCHAR (10), (), 103), 7) AS [mm / aaaa] | dez/05 | |
DD / MM / AAAA | SELECT CONVERT (VARCHAR (10), GETDATE (), 103) AS [DD / MM / AAAA] | 19/02/1972 | AA / MM | SELECT CONVERT (VARCHAR (5) GETDATE (), 11) AS [YY / MM] | 99/08 | |
DD.MM.YY | SELECT CONVERT (VARCHAR (8) GETDATE (), 4) AS [DD.MM.YY] | 25.12.05 | AAAA / MM | SELECT CONVERT (VARCHAR (7) GETDATE (), 111) AS [AAAA / MM] | 2005/12 | |
DD.MM.AAAA | SELECT CONVERT (VARCHAR (10), GETDATE (), 104) AS [DD.MM.AAAA] | 25.12.2005 | Mês DD, AAAA 1 | SELECT DATENAME (MM, GETDATE ()) + RIGHT (CONVERT (VARCHAR (12), GETDATE (), 107), 9) AS [DD mês, aaaa] | 4 de julho de 2006 um | |
DD-MM-AA | SELECT CONVERT (VARCHAR (8) GETDATE (), 5) AS [DD-MM-AA] | 24/01/1998 | AAAA 1 seg | SELECT SUBSTRING (CONVERT (GETDATE VARCHAR (11), (), 113), 4, 8) AS [AAAA seg.] | 1 abr 2006 | |
DD-MM-AAAA | SELECT CONVERT (VARCHAR (10), GETDATE (), 105) AS [DD-MM-AAAA] | 24/01/1998 | Mês YYYY1 | SELECT DATENAME (MM, GETDATE ()) + '' + CAST (YEAR (GETDATE ()) AS VARCHAR (4)) AS [AAAA mês] | Fevereiro de 2006 1 | |
DD AA 1 seg | SELECT CONVERT (VARCHAR (9) GETDATE (), 6) AS [DD seg YY] | 04 de julho 06 1 | DD 1 mês | SELECT CAST (DAY (GETDATE ()) AS VARCHAR (2)) + '' + DATENAME (MM, GETDATE ()) AS [Mês DD] | 11 01 desetembro | |
DD YYYY 1 seg | SELECT CONVERT (VARCHAR (11), GETDATE (), 106) AS [seg DD YYYY] | 04 de julho de 2006 um | DD 1 mês | SELECT DATENAME (MM, GETDATE ()) + '' + CAST (DAY (GETDATE ()) AS VARCHAR (2)) AS [Mês DD] | 11 de setembro um | |
Seg DD, AA 1 | SELECT CONVERT (VARCHAR (10), GETDATE (), 7) AS [seg DD, AA] | 24 de janeiro, 98 1 | DD AA 1mês | SELECT CAST (DAY (GETDATE ()) AS VARCHAR (2)) + '' + DATENAME (MM, GETDATE ()) + '' + RIGHT (CAST (YEAR (GETDATE ()) AS VARCHAR (4)), 2) AS [DD mês YY] | Fevereiro 19 72 1 | |
Seg DD, AAAA 1 | SELECT CONVERT (VARCHAR (12), GETDATE (), 107) AS [seg DD, AAAA] | 24 de janeiro de 1998 um | DD YYYY 1mês | SELECT CAST (DAY (GETDATE ()) AS VARCHAR (2)) + '' + DATENAME (MM, GETDATE ()) + '' + CAST (YEAR (GETDATE ()) AS VARCHAR (4)) AS [Mês YYYY DD ] | 11 setembro de 2002 um | |
HH: MM: SS | SELECT CONVERT (VARCHAR (8) GETDATE (), 108) | 03:24:53 | MM-AA | SELECT RIGHT (CONVERT (VARCHAR (8) GETDATE (), 5), 5) AS [MM-AA] | dez/92 | |
Seg DD YYYY HH: MI SS: MMMAM (ou PM) 1 | SELECT CONVERT (VARCHAR (26), GETDATE (), 109) | Abril 2006 12:32:29:253 PM 28 1 | SELECT SUBSTRING (CONVERT (VARCHAR (8) GETDATE (), 5), 4, 5) AS [MM-AA] | |||
MM-AAAA | SELECT RIGHT (CONVERT (GETDATE VARCHAR (10), (), 105), 7) AS [MM-AAAA] | mai/06 | ||||
MM-DD-AA | SELECT CONVERT (VARCHAR (8) GETDATE (), 10) AS [MM-DD-AA] | 01/01/2006 | YY-MM | SELECT RIGHT (CONVERT (VARCHAR (7) GETDATE (), 120), 5) AS [YY-MM] | 92/12 | |
MM-DD-AAAA | SELECT CONVERT (VARCHAR (10), GETDATE (), 110) AS [MM-DD-AAAA] | 01/01/2006 | SELECT SUBSTRING (CONVERT (VARCHAR (10), GETDATE (), 120), 3, 5) AS [YY-MM] | |||
AA / MM / DD | SELECT CONVERT (VARCHAR (8) GETDATE (), 11) AS [YY / MM / DD] | 98/11/23 | AAAA-MM | SELECT CONVERT (VARCHAR (7), GETDATE (), 120) AS [AAAA-MM] | 2006-05 | |
AAAA / MM / DD | SELECT CONVERT (VARCHAR (10), GETDATE (), 111) AS [AAAA / MM / DD] | 23/11/1998 | MMDDYY | SELECT REPLACE (CONVERT (VARCHAR (10), GETDATE (), 1), '/','') AS [MMDDYY] | 122506 | |
YYMMDD | SELECT CONVERT (VARCHAR (6) GETDATE (), 12) AS [YYMMDD] | 980124 | MMDDAAAA | SELECT REPLACE (CONVERT (VARCHAR (10), GETDATE (), 101), '/','') AS [MMDDAAAA] | 1,2E+07 | |
AAAAMMDD | SELECT CONVERT (VARCHAR (8) GETDATE (), 112) AS [AAAAMMDD] | 19980124 | DDMMAA | SELECT REPLACE (CONVERT (VARCHAR (10), GETDATE (), 3), '/','') AS [DDMMAA] | 240702 | |
DD HH AAAA Mon: MM: SS: MMM (24h) 1 | SELECT CONVERT (VARCHAR (24), GETDATE (), 113) | 28 de abril de 2006 00:34:55:190 1 | DDMMAAAA | SELECT REPLACE (CONVERT (VARCHAR (10), GETDATE (), 103), '/','') AS [DDMMAAAA] | 2,4E+07 | |
HH: MI: MMM (24h): SS | SELECT CONVERT (VARCHAR (12), GETDATE (), 114) AS [HH: SS:: MI MMM (24H)] | 11:34:23:013 | Seg-YY 1 | SELECT REPLACE (RIGHT (CONVERT (VARCHAR (9) GETDATE (), 6), 6), '', '-') AS [MON-YY] | Set-02 1 | |
AAAA-MM-DD HH: MI: SS (24) | SELECT CONVERT (VARCHAR (19), GETDATE (), 120) | ######## | Mon-YYYY1 | SELECT REPLACE (RIGHT (CONVERT (VARCHAR (11), GETDATE (), 106), 8), '', '-') AS [Mon-YYYY] | Set-2002 1 | |
AAAA-MM-DD HH: SS.mmm (24h): MI | SELECT CONVERT (VARCHAR (23), GETDATE (), 121) | 1972-02-19 06:35:24.489 | DD-MON-YY 1 | SELECT REPLACE (CONVERT (VARCHAR (9) GETDATE (), 6), '', '-') AS [DD-MON-YY] | 25-Dez-05 1 | |
DD-Mon-YYYY 1 | SELECT REPLACE (CONVERT (VARCHAR (11), GETDATE (), 106), '', '-') AS [DD-Mon-YYYY] | 25-Dez-2005 1 | ||||
AAAA-MM-DDTHH: MM: SS: MMM | SELECT CONVERT (VARCHAR (23), GETDATE (), 126) | 1998-11-23T11: 25:43:250 | ||||
DD HH AAAA Mon:: SS MI: MMMAM 1 | SELECT CONVERT (VARCHAR (26), GETDATE (), 130) | 28 de abril de 2006 12:39:32:429 AM 1 | ||||
DD / MM / AAAA HH: SS:: MI MMMAM | SELECT CONVERT (VARCHAR (25), GETDATE (), 131) | 28/04/2006 12:39:32:429 AM |
Nenhum comentário:
Postar um comentário
Informações de contato
Nome:
E-mail:
Telefone: