topic Re: Convert timestamp to date in Application Development and Automation Discussions

Convert timestamp to date

former_member463678 — Thu, 29 Aug 2013 09:57:18 GMT

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.

Re: Convert timestamp to date

rajesh_akarte2 — Thu, 29 Aug 2013 10:04:32 GMT

Hi,

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

Regards,

Rajesh Akarte

Re: Convert timestamp to date

FredericGirod — Thu, 29 Aug 2013 10:07:10 GMT

Hi,

it's not a timestamp

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

regards

Fred

Re: Convert timestamp to date

Former Member — Thu, 29 Aug 2013 10:09:08 GMT

Hello,

use this

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

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

Chandra..

Re: Convert timestamp to date

Former Member — Thu, 29 Aug 2013 19:13:20 GMT

Hi,

Check the link

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

Try out the function modules mentioned. Hope it helps.

Regards,

Eldho Jacob

Re: Convert timestamp to date

former_member463678 — Fri, 30 Aug 2013 06:47:56 GMT

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.

Re: Convert timestamp to date

Former Member — Fri, 30 Aug 2013 07:31:12 GMT

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