Discussions

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

Bookmark and Share Get thread feed

  1. query retruns different results (4 messages)

    • Posted by: sirisha koka
    • Posted on: March 01 2005 13:29 EST
    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
    Reply to this

    Threaded Messages (4)

  2. Re: query retruns different results[ Go to top ]

    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?
    Reply to this Reply to original

  3. Re: query returns different results[ Go to top ]

    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.
    Reply to this Reply to original

  4. Re: query returns different results[ Go to top ]

    Was that what was really in your code? Or was it a typo in your posting?
    Reply to this Reply to original

  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.
    Reply to this Reply to original