Re: Birth Day Calculation - Mailing list pgsql-sql

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