RE: Help on querying between dates

[Kipp, James]

THANKS !!!!

> -----Original Message-----
> From: Hapworth, Adam [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 25, 2002 10:51 AM
> To: Kipp, James; [EMAIL PROTECTED]
> Subject: RE: Help on querying between dates
> 
> 
> you could use the Oracle function of trunc() on your dates.  
> Like this:
> 
>       my $sth = $dbh->prepare("
>                               SELECT * 
>                                       FROM stats
>                                       WHERE sdate BETWEEN 
> trunc($fromDate)
> AND trunc($toDate)");
>           or die "Cannot prepare SQL statements from $DBI::errstr\n";
> 
> The trunc function used like that on a date returns jsut the 
> date portion
> and not the time.
> 
> Adam
>