Ashish Karalkar escreveu:
> Hello All,
>
> I want to diplay all the name of persons who falls in between given day
> and month
> something like
>
> select name from my_table mt where mt.date_of_birth between 7-Jul and
> 15 - Aug
>
>
> column date_of_birth is of date type
>
SELECT name FROM my_table mt
WHERE to_char(mt.date_of_birth,'mmdd') between '0707' and '0815'
Osvaldo