8 Replies Latest reply: Jan 7, 2010 1:13 AM by Hoek RSS

    TO_char ------------- To_date

    739340
      Asalam and hello every one...


      i am having a bit concept problem.. i have a condition that

      my created_date should be greather then and equal to 26-nov-2009 and it should return 605 records

      now when i am doing it with following method its returning 31 rows

      where to_char(a.created, 'dd-mon-rr') >= '26-nov-09'

      but if i do it with this method its working perfectly fine..

      where to_date(a.created, 'dd-mon-rr') >= '26-nov-09'

      now i want to know why its not returning all records when i am using to_char function