topic Re: Function Module for converting timestamp in Application Development and Automation Discussions

Function Module for converting timestamp

Former Member — Thu, 28 Jan 2010 06:53:06 GMT

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

Re: Function Module for converting timestamp

Former Member — Thu, 28 Jan 2010 07:01:29 GMT

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

Re: Function Module for converting timestamp

Former Member — Thu, 28 Jan 2010 07:02:02 GMT

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

Re: Function Module for converting timestamp

Former Member — Thu, 28 Jan 2010 07:04:22 GMT

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.