SELECT * FROM yourtable WHERE datcol BETWEEN '2005-01-25' AND '2005-07-31'

##</code><code>##

my $rc = $DB->sql("SELECT SUM(Size_Byte) FROM Files_U WHERE Type ='doc'");
die "ERROR: $rc" if $rc;
use Data::Dumper;
while( my $row = $DB->FetchRow ){
  warn Dumper $row;
}