FM for Timestamp calculation
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,
Try this FM