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