psangelotti2 wrote:

>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'
>
>

Try this, it's from memory and not tested:

select name, dtnasc, telephone
from customers
where
extract(month from dtnasc)=9
order by dtnasc



[Non-text portions of this message have been removed]