This discussion is archived
3 Replies Latest reply: Oct 17, 2012 1:27 AM by Marwim RSS

How to fetch column data by comparing dates?

955649 Newbie
Currently Being Moderated
Hi sir,

i am fetching one record based on date but not able to fetch the data.

in my table pdate column is there with date datatype and value is in that is:15-OCT-12
so i am fetching empid based on dates.

select emp_id from masterprocessdailydata where pdate=to_date('15-Oct-2012 00:00:00','dd-mon-yyyy hh24:mi:ss');
but not getting the empid.

thanks.

Legend

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