8 Replies Latest reply: Jan 7, 2010 1:07 AM by 739340 RSS

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

      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