topic Re: Convert seconds into date & time in Application Development and Automation Discussions

Convert seconds into date & time

former_member280027 — Mon, 19 Sep 2005 15:12:25 GMT

Hi Friends,

please help me to convert seconds into date & time, if any FM available in SAP?

Cheers,

Thayalan

Re: Convert seconds into date & time

Former Member — Mon, 19 Sep 2005 15:28:06 GMT

I guess you are trying to convert time stamp.

Try IB_CONVERT_FROM_TIMESTAMP .

Re: Convert seconds into date & time

Former Member — Mon, 19 Sep 2005 15:37:54 GMT

I am not sure how you can? You need some date and time plus seconds to calculate the resultant date and time.

If I give 3600 seconds as input and ask for the date and time, how can it be calculated without a reference date and time? I just know that it is 1 hour, but I cannot give it a date time stamp.

Can you please restate your requirement?

regards,

Srinivas

Re: Convert seconds into date & time

Former Member — Mon, 19 Sep 2005 19:40:45 GMT

If you want to convert some number of seconds into the number of days, hours, minutes and seconds:

REPORT ztest LINE-SIZE 250.

DATA: seconds TYPE i VALUE 180001,
      days    TYPE i,
      dur_ti  LIKE sy-uzeit.

days = seconds DIV 86400.      "Seconds per day
seconds = seconds MOD 86400.
dur_ti = seconds.

WRITE : /001 days, dur_ti.

It doesn't make sense to convert the number of days into years, months and days because both months and years can have different number of days.

Rob

Re: Convert seconds into date & time

former_member280027 — Tue, 20 Sep 2005 08:24:24 GMT

Hi Rob,

It was helpful answer for me,But I've solved the problem by using calling some UNIX rountines.

Thanks.

Re: Convert seconds into date & time

athavanraja — Tue, 20 Sep 2005 09:18:48 GMT

can you share the UNIX routine here

Thanks in advance.

Regards

Raja