i need to fetch the data with all columns from a table based on the condition where update_date<9/15/2011 4:59:27 pm

Well, then just do that.
What's your question?

my question is i need to fetch the data from source table and staging table based on the update_date( it is in the format like
10/26/2002 5:52:58 AM) attribute and do the minus query to test the count?pls let me know for further clarification on the question raised by me.

Please post the structure of your tables (ideally as CREATE TABLE statements)
Post some sample data
Post the desired output based on the sample data
And post anything you have tried so far.

Btw: DATE columns don't have a format...