3 Replies Latest reply: Oct 31, 2012 1:24 PM by rp0428 RSS

    Where with Date returns only one day 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.