You could also use the Oracle to_date function with a format string
to format your dates.
--- "Hapworth, Adam" <[EMAIL PROTECTED]> wrote:
> 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
>
>
>
> > -----Original Message-----
> > From: Kipp, James [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, July 25, 2002 10:43 AM
> > To: [EMAIL PROTECTED]
> > Subject: Help on querying between dates
> >
> > I have a cgi query form where the user selects a date range to
> get data
> > from.
> > I used SYSDATE as a means of inserting the date/time stamp into
> the table.
> > But the user will be entering the dates like: 7/01/2002 to
> 7/25/2002.
> > SYSDATE puts the dates in like '7/23/2002 10:38:10 AM' my
> question is how
> > can i match on this date. Should i use perl to format the date or
> use the
> > Oracle/SQL query itself to match the date. What Oracle options
> could i use
> > to do this.
> > Thanks
> >
> > Here is the relevant code, so far:
> > --
> > # get the date strings from the form
> > my $fromDate = $q->param('fromDate');
> > my $toDate = $q->param('todate');
> > ......
> >
> > # plug into query
> > my $sth = $dbh->prepare("
> > SELECT *
> > FROM stats
> > WHERE sdate BETWEEN $fromDate AND $toDate");
> > or die "Cannot prepare SQL statements from $DBI::errstr\n";
> >
__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
