Function Module for converting timestamp

[Former Member]

Hi all

I have a scenario where in the timestamp is getting stored in a z table in the UTC format (i.e. 20,100,125,080,528).

Now when i have to display this value to the user, it should be like "25.01.2010 08:05:28". Is there any standard function module to accomplish this? or is it like i have to do it in my code using the offset?

please guide me.

Thanks in advance.

Regards

Gaurav

[Former Member]

Hi,

U can use Standard SAp FM, can also use Offset.

Simple --Goto -> SU01> Give the User Name> Click Change burtton> Click on Defaults Tab--. Can Change the Date Format.

Regards

Arbind

[Former Member]

you can use the class CL_ABAP_TSTMP for arithmetical operations with time stamps.

please check the link..

http://www.sapnet.ru/abap_docu/ABENTIME-STAMP-GENERAL.htm

[Former Member]

Hello

Use this:

DATA: 
tstamp  TYPE timestamp, 
d TYPE D VALUE '19971224', 
t TYPE T VALUE '235500'.
CONVERT TIME STAMP tstamp TIME ZONE 'UTC+12' INTO DATE d TIME t.

Just press F1 on TIME STAMP.