Convert date time timestamp timezone

[h_senden2]

Hi,

i have a question about an issue which is talked about a lot in this forums but i haven't found a useful answer yet. So i will ask it again.

I want to convert

given date + time + timezone (20070606 + 112530 + UTC)

into

timestamp in another timezone (for instance CET).

How can i do this ?

regards,

Hans

[Simha_]

Hi,

Use this F.M..

CIF_GEN_CONVERT_TIMESTAMP

Cheers,

Simha.

reward if helpful..

[h_senden2]

Hi,

fm CIF_GEN_CONVERT_TIMESTAMP can not be found on my system, SAP BW 3.1.

regards,

Hans

[Former Member]

Hi,

Look at the blog

/people/himanshu.gupta/blog/2006/11/14/abap4-date-time-and-timestamps

Regards

Sudheer

[h_senden2]

Hi Sudheer,

thanx for the useful info, but after building a test program, i have still a question :

data: l_d type d,
      l_t type t,
      l_ts type timestamp,
      l_tz type timezone value 'CET'.

start-of-selection.

l_d = '20070606'.
l_t = '112530'.
l_tz = 'CET'. " 

* convert the UTC date 20070606 time 112530 into CET
convert date l_d time l_t into time stamp l_ts time zone l_tz.

write: / l_ts.
* Result is 20070606092530
* Result is CET

Result of the program is 20070606092530,

but this is incorrect. The value should be 20070606132530

See <a href="http://www.timeanddate.com/worldclock/converted.html?day=6&month=6&year=2007&hour=11&min=25&sec=0&p1=0&p2=37">http://www.timeanddate.com/worldclock/converted.html?day=6&month=6&year=2007&hour=11&min=25&sec=0&p1=0&p2=37</a>

Any suggestions ? Or is there something wrong in my program ?

regards,

Hans

[h_senden2]

Anyone ?

[h_senden2]

No one ?