We are reading external SQL database through our ABAP program.
Records are being fetched successfully. However, the records that we are getting contains date and time in the format 39934.02423, which corresponds to 01/05/2009 00:34:53 when formatted in excel.
The question is how do we convert this in our ABAP program so that we get '39934' as 01/05/2009 and the decimal part '02423' as 00:34:53 ?
Any help will be highly appreciated.