Hi,
I have a query where I am comparing different date formats in a trigger and sometimes the trigger doesn't fire. The where clause is like this..
WHERE v_req_date BETWEEN TO_DATE (startdate,'MM-DD-YY') AND to_date (enddate, 'MM-DD-YY')
v_req_date can be of the format MM/DD/YYYY or MM/DD/YYYY HH:MM:SS and startdate and enddata are of the format MM/DD/YYYY.
Why would the trigger not fire at times?
Thanks in advance for your comments.
A/A