1 Reply Latest reply on Nov 30, 2013 8:18 PM by rp0428

    Dates splitting

    saurabhkumar2988

      I have a table with column

      emp_number  , stay_from_date, stay_to_date,

       

      If the record are stored like this

       

      545944 1-jan-2013 10-jan-2013

      545933  3-jan-2013  6 jan 2013

       

      then the query should display output like

       

       

       

      545944  1-jan-2013  2-jan-2013

      545944  3-jan-2013  6-jan-2013

      545933  3-jan-2013  6 jan 2013

      545944  7-jan-2013  10-jan-2013

       

      can anyone help me in this query.