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')";

##</code><code>##

CDATE
---------
01-JAN-02
01-FEB-02
01-MAR-02
01-APR-02
01-MAY-02
01-JUN-02
01-JUL-02
01-AUG-02
01-SEP-02
01-OCT-02
01-NOV-02
01-DEC-02

##</code><code>##

CDATE
---------
01-JUL-02
01-AUG-02
01-SEP-02
01-OCT-02
01-NOV-02
01-DEC-02

##</code><code>##

no rows selected