my $statemenet = "select id
from comments
where comment_date >= to_date('01-jul-2002','dd-mon-yyyy')
and comment_date <= to_date('01-dec-2002',dd-mon-yyyy')";