Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Timestamp in cluster tables

former_member130219
Participant
0 Kudos

Why do we use the field TIMESTAMP in cluster tbles.

Please explain....

Thanks..

3 REPLIES 3

former_member242255
Active Contributor
0 Kudos

The timestamp is the date and time relative to the UTC (Universal coordinated time).

To normalize local times in a UTC time stamp and make them comparable, they must be converted using their time zone and the ABAP command convert

As explained above,it is used for the syncronisation acroos different time zones.

Former Member
0 Kudos

Hi ,

Go through the below data .

Working with Timestamp

An extension of the DATE data type that can store date and time data (including fractional seconds).

The ABAP Dictionary contains the data elements TIMESTAMP, TIMESTAMPL,

TIMESTAMP = P(8) Decimal 0

TIMESTAMPL = P(11) Decimal 7 ( decimal for fraction of second)

Commands

GET TIME: Places the current time in the system field SY-UZEIT. At the same time, SY-DATUM is set, and the system fields for the local time zone (SY-TIMLO,SY-DATLO, and SY-ZONLO) are refreshed.

GET TIME STAMP FIELD <F> Returns the timestamp in short or long form. The short form contains the current date and time; the long form also contains seven decimal places for fractions of a second, making the timestamp accurate to within 100 nanoseconds.

*--To get the Current Date/Timestamp

get time stamp field v_gv_curr_timest.

Hope it helps you.

regards,

Anusha V

former_member130219
Participant
0 Kudos

Thank you..