I have time stamp in the CREATE_DATE column of my table in the below format.
9/8/2016 5:37:35 AM
and CREATE_DATE BETWEEN '09/08/2016 5:59:17 AM' AND '09/08/2016 5:59:17 PM';
What you tried is a comparison of a date (a numeric type with a very special meaning) against STRINGS. This will never work.
If CREATE_DATE is indeed a DATE in Oracle, then this should work:
... AND CREATE_DATE BETWEEN to_date('09/08/2016 5:59:17 AM', 'mm/dd/yyyy hh:mi:ss AM') AND to_date('09/08/2016 5:59:17 PM', 'mm/dd/yyyy hh:mi:ss PM')
assuming 09/08 means September 8; if instead it is supposed to mean 9 August, then change mm/dd to dd/mm in the format models. Good luck!