when I run the below query its not showing me the records of 24/02/05 and I can see that they are records existing for 2/24. can anyone tell why i'm not able to see those records when i run this query.
FROM tab1e1 A, table2 B, table3 C,
table4 D,table5 E
WHERE B.REQUEST = A.REQUEST
AND C.STATUS_C = B.STATUS_C
AND C.REASON_C = B.REASON_C
AND E.PROCESS_STATUS_C = B.PROCESS_STATUS_C
AND B.LAST_UPDATE_S >= to_date('24/02/2005','MM/DD/YYYY')
AND B.LAST_UPDATE_S < = to_date('24/02/2005','MM/DD/YYYY')
AND D.STATUS_C = B.STATUS_C
ORDER BY B.LAST_UPDATE_C,B.LAST_UPDATE_S DESC
You're specifying the pattern as 'MM/DD/YYYY', but you're passing in '24/02/2005'. Are you querying for the 2nd day of the 24th month?
I'm looking for 24'th day in Feb month. I'm sorry I have given a wrong input date in my message. The correct date is 02/24/2005.
Was that what was really in your code? Or was it a typo in your posting?
It was just my typo and not in the code. I still have the same problem. please advice.