Time Subtract

[Former Member]

Hello.

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

Thank you.

[Former Member]

Hi

You can use FM <b>C14Z_CALC_DATE_TIME</b>

Inputs

<b>Seconds</b> (In your case -ve, as you want to substract time)

<b>Time</b>

<b>Date</b>

Regards,

Raj

[Former Member]

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 <b>GET_DELTA_TIME_FROM_DT</b>

Regards,

Sailaja.

Message was edited by: Sailaja N.L.

[Former Member]

Hi

You can use FM <b>C14Z_CALC_DATE_TIME</b>

Inputs

<b>Seconds</b> (In your case -ve, as you want to substract time)

<b>Time</b>

<b>Date</b>

Regards,

Raj

[Former Member]

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]

try TIMESTAMP_DURATION_SUB.

~Suresh

[Former Member]

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.