set serveroutput on 
declare
  v_date  date;
begin
   for record in (select <key fields>, datetimestamp from table) loop
     begin 
       v_date := to_date(record.datetimestamp,'dd/mm/yyyy hh:mi:ss am');
     exception when others then
       dbms_output.put_line('Error on '||record.<key fields>);
     end;
   end loop;
end;

to_date(datetimestamp,'dd/mm/yyyy hh:mi:ss am'), numberpacketssent
..
AND TO_DATE(datetimestamp,'mm/dd/yyyy hh:mi:ss am') 

AND to_char(datetimestamp,'dd/mm/yyyy hh24:mi:ss') between ('23/11/2006 17:45 :00')
and ('23/11/2006 17:50:36')

AND to_char(datetimestamp,'dd/mm/yyyy hh24:mi:ss') between ('23/10/2006 17:45 :00')
and ('23/11/2006 17:50:36')

AND datetimestamp between to_date('23/11/2006 17:45:00', ,'dd/mm/yyyy hh24:mi:ss')
and to_date('23/11/2006 17:50:36', ,'dd/mm/yyyy hh24:mi:ss')

SQL> 
SQL> create table test_date (proper_date date, string_date varchar2(30));

Table created.

SQL> 
SQL> insert into test_date values (to_date('23/11/2006 17:45:05','dd/mm/yyyy hh24:mi:ss'), '23/11/2006 17:45:05');

1 row created.

SQL> 
SQL> select * from test_date
  2  where proper_date between
  3  to_date('23/11/2006 17:45:00','dd/mm/yyyy hh24:mi:ss')
  4  and to_date('23/11/2006 17:50:00','dd/mm/yyyy hh24:mi:ss');

PROPER_DA STRING_DATE
--------- ------------------------------
23-NOV-06 23/11/2006 17:45:05

SQL> 
SQL> select * from test_date
  2  where string_date between
  3  to_date('23/11/2006 17:45:00','dd/mm/yyyy hh24:mi:ss')
  4  and to_date('23/11/2006 17:50:00','dd/mm/yyyy hh24:mi:ss');
where string_date between
      *
ERROR at line 2:
ORA-01843: not a valid month

SELECT to_date(datetimestamp,'dd/mm/yyyy hh:mi:ss am')
FROM calldetailrecorddiagnostic@raghu cmr, calldetailrecord@raghu cdr
WHERE (cmr.globalcallid_callmanagerid = cdr.globalcallid_callmanagerid)
AND (cmr.globalcallid_callid = cdr.globalcallid_callid)
AND ( (cmr.directorynum = cdr.callingpartynumber)
OR (cmr.directorynum = cdr.finalcalledpartynumber)
)
AND ( (cmr.callidentifier = cdr.origlegcallidentifier)
OR (cmr.callidentifier = cdr.destlegidentifier)
)
AND (cmr.globalcallid_clusterid = cdr.globalcallid_clusterid)
AND ( (cmr.jitter > 0)
OR (cmr.numberpacketslost > 0)
OR (cmr.latency > 0)
)
AND TO_DATE(datetimestamp,'mm/dd/yyyy hh:mi:ss am') 
BETWEEN to_date('11/23/2006 5:45:00 PM','MM/DD/YYYY HH:MI:SS AM') 
AND to_date('11/23/2006 5:50:00 PM','MM/DD/YYYY HH:MI:SS AM')