Skip to Content
avatar image
Former Member

FM for Timestamp calculation

Hello everyone,

does anyone knows if there is a FM that calculates timestamp time additions?

I have a timestamp ( using CONVERT ..... INTO TIMESTAMP) i want to add to the timestamp value, some minutes

Example: timestamp = 20070816220000 and i want to add 15 minutes to this value. I tried :

1) add 15_minutes to timestamp - if i do this inside a DO ...ENDDO

the timestamp value get's wrong at some point.

20070816226000 + 15m = 20070816229000 instead of 20070816231500

2) i also try to use CONVERT ..... INTO TIMESTAMP with the modified minutes (already added ) inside the loop, but couldn't control the passage from 20070816235959 to 20070817000000, because the date didn't change to 17, it begins again from 20070816000000 day 16.

Can anyone help please,

Best Regard's,

Pedro

Pedro Rosa

null

null

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 17, 2007 at 04:44 PM

    Hi Pedro,

    Use the function module <b>ADDR_ADD_TO_TIMESTAMP</b> to add seconds to timestamp. This function module adds time in seconds.

    Thanks,

    Vinay

    Add comment
    10|10000 characters needed characters exceeded