SQL & PL/SQL

To a procedure i'm passing date as input parameter

      procedure test (ipd_date date )   
	 Example format is   TO_DATE ('05/24/2012 09:26:46 PM', 'MM/DD/YYYY HH:MI:SS PM)
	  

In a table also the data is loading in the above format. Table column is DATE type
Now i need to compare the in parameter ipd_Date with the column in the table

	  BEGIN
	 select count(*) into  v_cnt
	   FROM test_tab
	    where dt = ipd_date.
      

Though the record in the table is also having the same format TO_DATE ('05/24/2012 09:26:46 PM', 'MM/DD/YYYY HH:MI:SS PM)
I'm not getting any row
How to compare those values .

Could you help me in this.

Edited by: Smile on May 25, 2012 9:45 AM