Convert timestamp to date

[former_member463678]

Hello experts,

I have a time stamp field in a table that shows the number of seconds since 1.1.1990,0:00 GMT * 10000 to a certain date. I have to convert it to date.

Here's an example of time stamp I'm trying to convert into date.

7,464,851,370,000  (This shows the number of seconds that elapsed since 1.1.1990)

Any suggestions would be appreciated.

Thanks in advance,

Zak.

[former_member463678]

Hello experts,

I have a time stamp field in a table that shows the number of seconds since 1.1.1990,0:00 GMT * 10000 to a certain date. I have to convert it to date.

Here's an example of time stamp I'm trying to convert into date.

7,464,851,370,000  (This shows the number of seconds that elapsed since 1.1.1990)

Any suggestions would be appreciated.

Thanks in advance,

Zak.

[rajesh_akarte2]

Hi,

Refer the post http://scn.sap.com/thread/1247966

Regards,

Rajesh Akarte

[FredericGirod]

Hi,

it's not a timestamp

timestamp (in abap world) it's  the concatenate : DATE TIME

regards

Fred

[Former Member]

Hello,

use this

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

http://scn.sap.com/thread/3190890

BR

Chandra..

[Former Member]

Hi,

Check the link

http://scn.sap.com/thread/1247966

Try out the function modules mentioned. Hope it helps.

Regards,

Eldho Jacob

[former_member463678]

Thanks all for your help.

I used function module 'RKE_TIMESTAMP_CONVERT_OUTPUT'.

I got it from Chandr's thread http://scn.sap.com/thread/3190890 and also from,

Matthew Billingham @ http://scn.sap.com/thread/715979

Regards,

Zak.

[Former Member]

Mark the ans as correct and helpful.. and closed it.