Коллеги,

Подскажите ФМ плиз, как преобразовать Oracle timestamp в datum? Или во что-нибудь абап-о-варимое. BWFS_TIMESTAMPS_OUTPUT почему-то не помогает или может кто-нибудь пример I_TIMESTAMP напишет как выглядит, если это оно.

спасибо

Internal Format of Time Stamps
A time stamp represents date and time in the form YYYYMMDDHHMMSS. YYYY is the year, MM the month, DD the day, HH the hour, MM the minutes and SS the seconds. There is a short form and a long form. In the long form, the form specified above additionally contains seven decimal places for fractions of seconds, which allow for an accuracy of up to 100 ns. The maximum time resolution depends on the operating system of the application server and can be less.

A valid time stamp must contain values, whose date and time specifications before the decimal separator correspond to valid values for the data types d and t. When specifying the time, only the values 00 to 23 for the hours, and 00 to 59 for the minutes are valid. Time stamps in this form are always considered as UTC time stamps when processed with the corresponding statements. Use the statement GET TIME STAMP to create a time stamp that represents the current UTC reference time.

Data Types for Time Stamps
For the short and long form of time stamps, the data types TIMESTAMP and TIMESTAMPL are available in the ABAP Dictionary. The respective ABAP types are p of length 8 without decimal paces (short form) and p of length 11 with seven decimal places (long form). Time stamps are stored in the format stated above in data objects of these types. Thus the decimal places before the decimal separator represent the date and the time and the fractional portion in the long form represents the fractions of seconds.

Note
In programs for which the program attribute Fixed point arithmetic is not set, beware of the rules applying for the data type p.

Пользуйтесь