Обсуждение: Birth Day Calculation

Поиск
Список
Период
Сортировка

Birth Day Calculation

От
"Ashish Karalkar"
Дата:
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
 
 
is there any way to do this
 
Thanks in advance
Ashish...

Re: Birth Day Calculation

От
Osvaldo Rosario Kussama
Дата:
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