I need to compare dates in different formats.
In the table the field (let's call it revoke_date) is defined as a Date type, and data is stored like 02-Dec-2005.
The application sends in data to the
JSP in mm/dd/yyyy format, stored in variable vDate, type
String.
How can I do soemthin like "select * from tbl1 where revoke_date = vDate"
properly?
Thank you.