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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
