Converting long date format - micro seconds are lost

Former Member — Wed, 25 Sep 2013 20:56:20 GMT

Hi all,

I am attempting to convert a long date format and the micro seconds are lost.

Sample code:

********************************************************************

data: l_long TYPE TIMESTAMPL,
l_short TYPE tzntstmps.

   DATA:
    l_timestamp TYPE tzntstmps,
    l_datlo     TYPE sy-datum,
    l_timlo     TYPE char20.

START-OF-SELECTION.

GET TIME STAMP FIELD l_long.

GET TIME STAMP FIELD l_short.

CONVERT TIME STAMP l_long TIME ZONE 'BRAZIL'
INTO DATE l_datlo TIME l_timlo.

************************************************************************

Results:

l_long = 20130925200307.6550000

l_datlo = 20130925

l_timlo = 170307 NOTE: the .6550000 is missing.

The SAP documentation on CONVERT states:

If the time stamp in time_stamp is in the long form, the seconds fractions in the decimal places are ignored.

I need the micro seconds. Other than using string processing (SPLIT and CONCATENATE) Does anyone know a good way to resolve this problem?

Regards,

Steve

Re: Converting long date format - micro seconds are lost

Former Member — Wed, 25 Sep 2013 21:58:29 GMT

Hi Steve,

Maybe this post helps you.

Regards,

Renzo.