sexta-feira, 14 de janeiro de 2011

Formatos De Datas No SQL SERVER

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












Leo***

Nenhum comentário:

Postar um comentário

Informações de contato
Nome:
E-mail:
Telefone: