12 replies to this topic

[Vanessa Piti]

Quando faço o select:

select datablog from blog

retorna uma data da seguinte maneira:
2004-09-20 09:39:39.843

Alguém sabe usar o comando CONVERT para que a data retorne dia-mês-ano?
20-09-2004

[TucaZ]

Tente:

SELECT CONVERT(datetime,campo_data,103) AS DATA FROM tabela

Abraços

[Vanessa Piti]

Tentei, mas a data retorna no mesmo formato. Até tentei trocar o código 103 para outros números, mas retorna a mesma coisa.

[Prog]

A forma correta de usar o convert é:
convert(converter_para_tipo(tamanho), expressao, formato)

Então sua resposta é:

select convert(varchar(10),campo_data,103) from tabela

[Vanessa Piti]

Funcionou!

Muuuuuuuito obrigado

[RonsisM]

Generic For Keflex cialis Dapoxetina
Is Biochem Letrozole Legit Comprare Viagra Online Sicuro
Asthma Inhalers Over The Counter <a href=http://cialtobuy.com>online pharmacy</a> Order Orlistat Online
Mail Order Online Provera Clinofem Real cialis buy online Viagra Professional 100 Mg
Cialis Ricetta Medica Amoxicillin Interactions With Metacam Cialis Da 20 Mg
Comprar De La Propecia <a href=http://cialtobuy.com>cialis</a> Cialis 20 Dosage

[RonsisM]

Toronto Drug Stor Viagra Postlagernd Bestellen Was Ist Cialis Tadalafil cialis Cytotec Ou Curetage Je shipped ups on line isotretinoin 10mg in usa
Sildenafil rique Surrey Kt12 Viagra Cialis Generique Pharmacie France viagra Buy Levitra?Overnight Delivery Acquistare Viagra Yahoo Tadalis Sx Vente 10 Mg

[RonsisM]

Buy Albuterol Inhaler Canada Precio Cialis Levitra Viagra viagra online pharmacy Kamagra Suppliers Zithromax Rhinopharyngite One Time Dose Amoxicillin
Comprar Cialis Online En Espana levitra cheap Photo Of Keflex Medikament Viagra 50 Mg
Trusted Onlone Pharmacy Can You Buy Diflucan Online Propecia Doping Efectos Colaterales cialis Discount fedex isotretinoin with overnight delivery medication overseas Cialis Modalita Assunzione Propecia Y Etanol

[RonsisM]

Amoxicillin Osage For 7 Month Old Ou Acheter Du Levitra Pas Cher Levitra Vs Viagra viagra Cialis Wikipedia

[Miguceamma]

Levitra Generika Vergleich Cialis Black 800mg Pills viagra Wie Wirkt Viagra Bei Der Frau Viaga Canada 411 Order Now Doryx In Internet

[LarPhozyHah]

Cephalexin Overdose Clomid Provames buy cialis Cialis 20 Mg Precio En Farmacias Where To Get Cheap Prescriptions
Canada Discount Tadalafil 20mg Baclofene Indication Hoa To Buy Alli Pills buy cialis Anafranil Mg Comprar Cialis Online Seguro
Amoxicillin With Cetalopram Kamagra Prix En Pharmacie viagra Viagra Et Nitrate
Msds Cephalexin Buy Cheap Diflucan Online buy viagra Comprar Levitra 10 Mg Levitra Filmtabletten Teilen

[RonsisM]

Buy Prednisone Acetate Eye Drops viagra cialis Buy Amoxicillin In Mexico Acheter Cialis Online
Tadalafil Online Bestellen European Med Comprar Cialis En Malaga viagra Cialis Achat En Ligne Canada Betta Fish Amoxicillin Cialis 2 5 Mg

[RonsisM]

Kamagra South Africa viagra Zithromax Tri Pak Priligy Romania Amoxicillin Liquid Side Effects Poop
Order Now Amoxicilina Antibiotic Cod Accepted Levitra Dauer Wirkung cialis Propecia Samples Online
Propecia Can Stop Baldness Zithromax Tri Pak Dose Keflex Acid Reflux cheap cialis Kamagra Sverige