Application Development and Automation 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: 
Read only

TIMESTAMPL - does it automatically default to GMT?

Former Member
0 Likes
973

Hello,

I am a bi analyst and am receiving data from ECC. I get current day/time and also timestamp (timestampl).

I can see that the current date/time is correct to our EST but the timestampl is 4 hours ahead. A few weeks ago it was 5 hours ahead (alas daylight saving time).

Is the timestampl default to GMT regardless? If so, is there any way that this can be adjusted without having to do a function module conversion?

Any help would be greatly appreciated since I am not an ABAP developer and am searching the best way to resolve....

Thanks,

Lynda

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
915

HI,

Concatenate the day and time into the timestamp variable.

Hello,

I am a bi analyst and am receiving data from ECC. I get current day/time and also timestamp (timestampl).

I can see that the current date/time is correct to our EST but the timestampl is 4 hours ahead. A few weeks ago it was 5 hours ahead (alas daylight saving time).

Is the timestampl default to GMT regardless? If so, is there any way that this can be adjusted without having to do a function module conversion?

Any help would be greatly appreciated since I am not an ABAP developer and am searching the best way to resolve....

Thanks,

Lynda

5 REPLIES 5
Read only

Former Member
0 Likes
916

HI,

Concatenate the day and time into the timestamp variable.

Read only

former_member156446
Active Contributor
0 Likes
915

I guess you might be getting the system time rather than local time...

sy-uzeit is the system/server time and

sy-TIMLO is the user time, check may be you can pull sy-TIMLO.

Read only

0 Likes
915

Who sets the system time? Is there no other way to get it to equal our EST time zone?

My problem is that someone modified this in ECC and I was told to use the timestamp to pull deltas.

I am getting all records - no problem with that - but I can see that the timestamp shows 4 hours ahead - thus I won't get the deltas until much later.

We run 2 process chains a day and I have my upper limit set to 1800 seconds (30 minutes).

I could take the upper limit off and pull in all deltas but SAP advises to use the 1800 second upper limit when timestamp is the pointer.

I would rather the timestamp data exactly match the date/time on the same record.

I had no involvement in the changes in ECC - I was just told to bring this new table in.

Read only

0 Likes
915

>

> Who sets the system time? Is there no other way to get it to equal our EST time zone?

your basis team will set that time, you need to pick the local time sy-timlo "system variable for local time

Read only

Former Member
0 Likes
915

Thanks to the postings to my question.

I found the function module and where it was getting pulled.

They used the abap code----->

Get Time Stamp field l_timestamp

I found ABAP help - UTC format is used which is always GMT.

I appreciate everyone's help.

Lynda