9 replies to this topic

[palhadecoco]

É o seguinte, tenho um campo na minha tabela do tipo DATE, bem quero selecionar na tabela apenas o mês e o ano, ñ a data completa, como se fosse assim:

SELECT *FROM tabela WHERE data='2006-11-25'

Bem dessa forma só vai selecionar a data exata, mas eu quero q apareçe o mês 11 e o ano 2006 todo.


Era tipo assim:

SELECT *FROM tabela WHERE data='2006-11'

Edição feita por: palhadecoco, 19/08/2006, 10:36.

[Kakao]

SELECT * FROM tabela WHERE month(data) = 11 and year(data) = 2006

[palhadecoco]

SELECT * FROM tabela WHERE month(data) = 11 and year(data) = 2006

Valeu amigo, deu certo.

[Miguceamma]

Legally isotretinoin from canada cod accepted pharmacy cialis buy brand name accutane
Allergy To Keflex Erectile Dysfunction Drugs Online Propecia Generic Drug Pharmacy
Generic Dutasteride <a href=http://cialtobuy.com>cialis online</a> No Prescription Lasix Online
Cephalexin And Cats Ear Infection cialis Cialis 400 Mg Viagra Packstation Order Clonidine Online Overnight Kamagra Prescription cialis High Dose And Low Dose Amoxicillin

[Miguceamma]

Propecia Ejaculation Cialis cialis Cialis Once A Day Opinioni Pharmaceuticals Viagra

[Miguceamma]

Direct Provera Order Is Generic Priligy Safe viagra Sildenafil Citrate Viagra Generic Comment Obtenir Cytotec Cephalexin Cap 500 Mg C
Apotheke Viagra Cialis Interacciones Medicamentosas Achat Cialis Quebec viagra Buy Cheap Lasix Secure Ordering Macrobid 100mg For Sale Tablet Cod
Herbal Propecia Clinically Proven cialis Is Prednisone From Overseas Safe

[HaroNism]

Pharmacie Cialis Sans Ordonnance viagra online pharmacy Amoxicillin With Astma Dosi Levitra

[Miguceamma]

Generic Levitra No Prescription cialis Ampicillin 500 Cialis Vs Viagra Cost

[Miguceamma]

Cheap Amoxicillin Without A Prescription cialis Propecia Paypal
Priligy Peru Achat Sildenafil 25 Mg Naturliches Viagra viagra Pharmacy Viagra Baclofen Generique En France
Metronodizole Discount Lioresal En Ligne France Zithromax Buy Online Uk viagra Cialis Generico Dove Comprare Commande Cialis En France

[Miguceamma]

online finasteride prescription Verwendung hauptsФchlich zur Definition DiФt aber teilweise auch zum Masseaufbau KurlФnge 4 6 Wochen Hersteller Gaspari Orastan A, Axis Labs Furazadrol Anmerkung es handelt sich hier um ein Ðâžquivalen zu Furazabol ohne 17aa
buy generic cialis I have not seen this in my medical practice, but any man who uses AIs chronically and has low or absent estrogen for years would be at risk for this
Ayden YsyizGabWxjDOwMDxEk 6 27 2022 priligy en france