i want to find records between two dates IN ORCALE but the table field values is in "mm/dd/yy hh:mm::ss" and data type is varchar2
The query which i was trying was:
SELECT * FROM NEW_OUTPUT_UPLOAD_TSN
WHERE OUTPUT_UPLOAD_DATE BETWEEN TO_DATE('01/13/2008 18:45:19','MM/DD/YYYY 24HH:MI:SS')
AND TO_DATE('01/13/2008 18:45:19','MM/DD/YYYY 24HH:MI:SS')