"Kipp, James" wrote:
>
> > 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";
>
>
i would think you would want to use the to_date function and not the
to_char function if you are trying to do something between a certain date
range in Oracle. the syntax for what you are doing should be documented
in the Oracle books. I know I have done what you are trying to do, I just
cant dig up the code right now.
--
-------------------------------
Just Your Friendly Neighborhood
_SPIDEY_
