SQL count not matching the results of perl script count

[jonathan184]

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

[miller]

Add error checking to your execute:

$sth1 = $repoCon->prepare($repoSQL);
$sth1->execute() or die $repoCon->errstr;
 

Also, your function TO_DATE does not appear to exist in the latest version of MySQL.

Maybe you need the STR_TO_DATE function instead?
http://www.mysql.org/doc/refman/5.1/en/date-and-time-functions.html

[jonathan184]

soory i forogt to mention this is linking to an oracle database and not mysql

Will put that error checking and see what happens thanks