Convert seconds into date & time

[former_member280027]

Hi Friends,

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

Cheers,

Thayalan

[Former Member]

I guess you are trying to convert time stamp.

Try IB_CONVERT_FROM_TIMESTAMP .

[Former Member]

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

[Former Member]

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

[former_member280027]

Hi Rob,

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

Thanks.

[athavanraja]

can you share the UNIX routine here

Thanks in advance.

Regards

Raja