topic Re: Problem in timestamp in Application Development and Automation Discussions

Problem in timestamp

Former Member — Fri, 20 Apr 2012 05:55:31 GMT

Hi Experts,

There was a problem in my time stamp.

In my web dynpro compinent i am using timestamp feature for comments.

for every comment i posted in a table i am also adding times stamp with this comment but when i see this time stamp in the table its giving wrong time

Following is the statement

CONVERT DATE sy-datum TIME sy-uzeit INTO TIME STAMP ls_comments-timestamp TIME ZONE sy-zonlo.

time zone sy-zonlo is EST. Time is showing almost 5 hours forward

Re: Problem in timestamp

Former Member — Fri, 20 Apr 2012 08:58:22 GMT

Hi,

I dont think you need to concatenate to get the timestamp.You can directly write like below:

get time stamp field v_timestamp.

For help you can refer to the below link:

http://help.sap.com/abapdocu_70/en/ABAPGET_TIME-STAMP.htm

Hope it solves your problem.

Re: Problem in timestamp

former_member209818 — Fri, 20 Apr 2012 09:00:51 GMT

In the table it must be storing the timestamp as per the system time-zone. Check your Time-Zone and System timzone.. I believe you will get the difference between these two time zone as 5 hours

Re: Problem in timestamp

Former Member — Fri, 20 Apr 2012 11:33:16 GMT

That's the way timestamp works. You have local time zone set as EST, the timestamp calculation is then based upon UTC - local time zone, for which I typically have a five hour difference. Try creating your time zone with time zone set to space in a variable. I did that, as I recall, to force local time into the table in one of my programs.

Re: Problem in timestamp

Former Member — Mon, 23 Apr 2012 08:01:17 GMT

No after writting like that also its giving 5hours more

Re: Problem in timestamp

Former Member — Wed, 25 Apr 2012 05:26:53 GMT

Thanks break Point,

now i am able to retrieve correct time.