09-25-2013 9:56 PM
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
09-25-2013 10:58 PM
Hi Steve,
Maybe this post helps you.
Regards,
Renzo.