Subject Select customers from month of birthday
Author psangelotti2
Hi all,
I am trying to select the customers born in one determined month and
I am not obtaining.
The syntax that I am using is the following one:
select name, dtnasc, telephone
from customers where month(dtnasc) = 9
order by dtnasc
I also tried: where month(dtnasc) = '9' and where month(dtnasc)
= 'AUG'
The objective is to print a list of aniversariantes of the August
month. Somebody would know to help me?
Since already, I am thankful.

Pedro Sergio Angelotti
Pontosoft Informática S/C Ltda.
http://www.pontosoft.com.br/