topic Re: Time Subtract in Application Development and Automation Discussions

Time Subtract

Former Member — Wed, 06 Sep 2006 10:09:52 GMT

Hello.

How can i subtract time from any given date/time?

Thank you.

Former Member — Wed, 06 Sep 2006 10:18:17 GMT

hi,

Check the fm SD_DATETIME_DIFFERENCE or GET_DELTA_TIME_FROM_DT

Check Rich post in this thread to know how to use fm GET_DELTA_TIME_FROM_DT

Regards,

Sailaja.

Message was edited by: Sailaja N.L.

Former Member — Wed, 06 Sep 2006 10:18:27 GMT

You can use FM C14Z_CALC_DATE_TIME

Inputs

Seconds (In your case -ve, as you want to substract time)

Time

Date

Regards,

Raj

Former Member — Wed, 06 Sep 2006 10:30:42 GMT

Hello,

What i need is not the difference bettwen 2 date/time. I need to subtract for example an hour from a date/time and get the result.

C14Z_CALC_DATE_TIME adds seconds without a problem but it work with negative seconds.

Thank you

Nuno Silva

suresh_datti — Wed, 06 Sep 2006 10:35:51 GMT

try TIMESTAMP_DURATION_SUB.

~Suresh

Former Member — Wed, 06 Sep 2006 10:38:25 GMT

hi,

You can subtract time directly, there is no need of FM.


data: v_time type t value '201010'.

v_time = v_time - 600.  "10min (10*60 = 600 seconds)
write :/ v_time.

Regards,

Sailaja.