Hi I am having a problme where the results of the sql count is not matching the results of the perl script sql count.
The script was working fine up till Wed last week and after that the results are different on sql and on perl and the date and times are the same, I even copy and pasted the sql query from the perl script into the sql window and got different results.
Here is part of the script where i am trying to get the count
$enter_date = " between to_date('11/22/06 15:24','mm/dd/yy hh24:mi:ss')
and to_date('11/22/06 15:30','mm/dd/yy hh24:mi:ss')";
$repoSQL = qq{
select count(*) from site s where (s.lastupdateddate) $enter_date
};
$sth1 = $repoCon->prepare($repoSQL);
$sth1->execute();
$kntr = $sth1->fetchrow_array() ;
$repoSQL = qq{
select count(*) from site s where (s.createddate) $enter_date
};
$sth2 = $repoCon->prepare($repoSQL);
$sth2->execute();
$kntr2 = $sth2->fetchrow_array() ;
print "Updated Count: $kntr \n
Created Count: $kntr2 ";
$message = "Please find the attached Site Error Report. The Site Error Report reports errors occurring in the last 15 days. \n\n
Number of records updated within the last 24 hours is: $kntr \n\n\n
Number of records created within the last 24 hours is: $kntr2";
--------------------------end--------------------------------
Hope you guys could help me out, I would really appreciate it.
Thanks
|