3 Replies Latest reply: Oct 17, 2012 3:27 AM by Marwim RSS

    How to fetch column data by comparing dates?

      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.