RE: Help on querying between dates

[Kipp, James]

  
> You could also use the Oracle to_date function with a format string
> to format your dates.

Thanks, adam
Something like this??:

my $sth = $dbh->prepare("
                        SELECT * 
                                FROM stats
                                WHERE sdate BETWEEN to_char($fromDate,
'DD/MM/YYY')
                        AND to_char($toDate,'DD/MM/YYY')
                                ";
    or die "Cannot prepare SQL statements from $DBI::errstr\n";