5 Replies Latest reply: Oct 30, 2012 7:53 PM by user2002208 RSS

    Where with to_date returms only one month data

    user2002208
      SELECT col1,col2 FROM bill WHERE
      trunc (TO_DATE(time_stamp, 'yyyy/mm/dd HH:MI:SS AM') = trunc (TO_DATE('2012/01','yyyy/mm');

      This only returns data for first day of the month and need data for a month.