This discussion is archived
3 Replies Latest reply: Oct 31, 2012 11:24 AM by rp0428 RSS

Where with Date returns only one day data

971542 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points