Skip to Content
0
Dec 29, 2010 at 12:52 PM

Converting Excel date and time format into SAP format

1292 Views

Hi,

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.

Warm Regards,

Firoz.