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

    Add days and minutes in fractional format to a timestamp

    Moonlight

      Hello,

       

      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