This function
Code:
SELECT  TO_DATE( '08/16/2004 01:00:00 A.M.',  'MM/Dd/YYYY HH:MI:SS A.M.' )  from dual
gives me "8/16/2004 1:00:00 AM"

wheras
Code:
SELECT  TO_DATE( '08/16/2004 12:00:00 A.M.',  'MM/Dd/YYYY HH:MI:SS A.M.' )  from dual
gives me just "8/16/2004"

I want the datetime stamp to be at 12:00:00 AM - What syntax should I use to get "8/16/2004 12:00:00 AM" in my result ?

Thanks.