4 Replies Latest reply on Jun 4, 2020 11:57 AM by Moonlight

    Add days and minutes in fractional format to a timestamp




      I need to add to a timestamp a number of days and minutes in fractional format  :


      select to_timestamp('30/12/1899 12:00:00','dd/mm/yyyy HH24:MI:SS:FF') + 40390.28033320 from dual;


      40390 is the number of days

      0.28033320 represent the minutes and seconds


      I only have the number of days added but not the minutes and seconds,  how do I get the minutes and seconds right?


      Best regards