calculate time in days

[former_member106270]

Dear all.

I need a function that calculates the time from microsecunds in days (Data type MEINS).

Best Regards,

Thanks In advanced.

Nada

[vinod_gunaware2]

<b>COPF_DETERMINE_DURATION</b> – Calculates difference between date and time

<b>SD_DATETIME_DIFFERENCE</b> – Difference in days and time for two dates . .

<b>SWI_DURATION_DETERMINE</b> – The time between two events in seconds .

regards

vinod

[Former Member]

I don't think there is built in function for the same, you will have to build one. Not to the extent of Micro seconds that you are looking for.

Regards,

Ravi

Message was edited by: Ravikumar Allampallam

[andreas_mann3]

Hi,

days = v_ms / 86400000

Andreas

[Former Member]

Hi Moalla!

Check out this link :

http://www.sapdevelopment.co.uk/tips/date/datehome.htm

Regards

Praneeth

Reward points if helpful !

[Former Member]

Hi !

You need to translate your microseconds into the Timestamp format.

Then you can use the:

CONVERT TIME STAMP tst TIME ZONE tz INTO DATE d TIME t.

Command.

Regards

Rainer

Some points would be nice of that helped a bit...

[former_member106270]

Thanks a lot for the answers!

actually what I have is 2 time stamps and I need to calculate the diffrence in days (data type MEINS)

Thanks!

[Former Member]

Hi Again!

In that case you can try this (diff between two time stamps) FM /SDF/CMO_DATETIME_DIFFERENCE

Regards

Praneeth

[former_member106270]

Thanks a lot!

I will try it out.

[former_member106270]

Hi Praneeth,

thanks!

in which system can I find the funtion module?

Regards,

Nada