topic Re: Error while creating timestamp in local (CET) timezone in Application Development and Automation Discussions

Error while creating timestamp in local (CET) timezone

SuhaSaha — Mon, 17 Feb 2014 10:12:28 GMT

Hello fellow SDNers,

I am getting the DST timestamp (-1 hrs) when i try to create the timestamp.

This is the code that i have written -

CONVERT DATE sy-datlo 
        TIME sy-timlo 
        INTO TIME STAMP DATA(locl_tstmp) 
        TIME ZONE sy-zonlo. 

Debugging session looks like this -

SAP documentation on CONVERT INTO TIMESTAMP says & i quote -


If the addition DAYLIGHT SAVING TIME is not specified, then the value of dst is set to "X" implicitly if the data in tim and dat is in summer time and is set to " " for data in winter time.

Refer. - ABAP Keyword Documentation

Am i missing something?

BR,

Suhas

Re: Error while creating timestamp in local (CET) timezone

nabheetscn — Mon, 17 Feb 2014 10:58:22 GMT

Hi Suhas

I tried one more thing apart from this. I create a local variable and give it a summer date. Now the timestamp contains 2 hours less.

So for winter for me it is subtracting one hour and for summer two hours without daylight addition.

Nabheet

Re: Error while creating timestamp in local (CET) timezone

Former Member — Mon, 17 Feb 2014 10:59:02 GMT

Check the timezone settings in tcode STZBC

Re: Error while creating timestamp in local (CET) timezone

SuhaSaha — Mon, 17 Feb 2014 11:08:00 GMT


DEBOPRIYO MALLICK wrote:

Check the timezone settings in tcode STZBC

I had already done that before posting, sorry for not mentioning that in my post.

Imo no sane person would mess with these anyway.

BR,

Suhas

Re: Error while creating timestamp in local (CET) timezone

SuhaSaha — Mon, 17 Feb 2014 11:11:50 GMT


So for winter for me it is subtracting one hour and for summer two hours without daylight addition.

I think you meant the other way round, DST is active in summer & not in winters

Re: Error while creating timestamp in local (CET) timezone

nabheetscn — Mon, 17 Feb 2014 11:12:30 GMT

Yes you are right what if we use sy-uzeit in place of local time?

Re: Error while creating timestamp in local (CET) timezone

SuhaSaha — Mon, 17 Feb 2014 12:21:00 GMT

Doesn't help either

I never thought about the difference between System & User Timezones, but yes in my case both are same.

Since in my case the user TZ = system TZ.

BR,

Suhas

Re: Error while creating timestamp in local (CET) timezone

Former Member — Mon, 17 Feb 2014 18:55:35 GMT

Hi Suhas

The output is correct.

The statement converts your date,time,timezone combination to system timestamp (UTC always).

I think you just want to get output as 20140217110409, the literal combination of datlo and timlo.

In this case you can "lie" to the statement, saying that timezone is UTC. As a result, UTC to UTC conversion would give you unchanged datetime.

DATA locl_tstmp TYPE timestamp. 
DATA utc TYPE sy-zonlo VALUE 'UTC'. 
DATA a TYPE sy-datlo VALUE '20140217'. 
DATA b TYPE sy-timlo VALUE '110409'. 
DATA c TYPE sy-zonlo VALUE 'CET'. 
CONVERT DATE a 
        TIME b 
        INTO TIME STAMP locl_tstmp 
        TIME ZONE c. 
WRITE😕 'suhas', locl_tstmp. 
CONVERT DATE a 
        TIME b 
        INTO TIME STAMP locl_tstmp 
        TIME ZONE utc. 
WRITE😕 'utc winter', locl_tstmp. 
a = '20141017'. 
CONVERT DATE a 
        TIME b 
        INTO TIME STAMP locl_tstmp 
        TIME ZONE utc. 
WRITE😕 'utc summer', locl_tstmp. 
 

Let me know if i understood the requirement incorrectly.

Re: Error while creating timestamp in local (CET) timezone

SuhaSaha — Mon, 17 Feb 2014 20:19:06 GMT


The statement converts your date,time,timezone combination to system timestamp (UTC always).

My bad - should have read the SAP documentation thoroughly (ABAP Keyword Documentation).


Time stamps in the ABAP runtime environment are POSIX time stamps independent of time zone.


In this case you can "lie" to the statement, saying that timezone is UTC.

I don't need a workaround. I just wanted to know why did the statement always return UTC timestamp irrespective of the TZ (and the DST settings)

I don't need the CONVERT INTO TIMESTAMP as well, i'll use GET TIMESTAMP. The reason i got confused was that the documentation of GET TIMESTAMP clearly states that it will generate UTC timestamp, but that of CONVERT INTO TIMESTAMP doesn't

So i assumed that the timestamps will be created in the TZ of the AppServer .

Thanks anyway.

BR,

Suhas

Note to me - When in doubt RTFM, always!