Discussions

Web tier: servlets, JSP, Web frameworks: query retruns different results

  1. query retruns different results (4 messages)

    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.

    Select *
    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
  2. 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?
  3. James,
    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.
  4. Was that what was really in your code? Or was it a typo in your posting?
  5. query retruns different results[ Go to top ]

    It was just my typo and not in the code. I still have the same problem. please advice.