topic Re: TIME in Application Development and Automation Discussions

TIME

Former Member — Mon, 19 Feb 2007 09:41:54 GMT

Hi Everybody,

I have The variables like,

Data : time1 like sy-uzeit value '102030',

time2 like sy-uzeit '102530'.

now I wants the difference between two times. If any Function module is there to do it. Thanks in Advance.

Re: TIME

Former Member — Mon, 19 Feb 2007 09:44:08 GMT

Check

SD_DATETIME_DIFFERENCE

SCOV_TIME_DIFF_46B

Re: TIME

Former Member — Mon, 19 Feb 2007 09:45:38 GMT

Hello,

L_MC_TIME_DIFFERENCE : Find the time difference between two date/time

Vasanth

Re: TIME

Former Member — Mon, 19 Feb 2007 09:45:45 GMT

try this

call function 'SD_DATETIME_DIFFERENCE'
           exporting
*                DATE1            = sy-datum
                 date1            = sy-datum
                time1            = time1
                date2            = dt_dlvy-wadat
                time2            = sy-uzeit
           importing
                datediff         = datediff
                timediff         = timediff
                earliest         = earliest
           exceptions
                invalid_datetime = 1
                others           = 2.

Re: TIME

Former Member — Mon, 19 Feb 2007 09:46:26 GMT

Just use Subtraction Operator between two variables.

Thanks,

Prashanth

Re: TIME

Former Member — Mon, 19 Feb 2007 09:48:01 GMT

hi Vijay,

Use FM SD_DATETIME_DIFFERENCE

Regards,

Santosh

Re: TIME

Former Member — Mon, 19 Feb 2007 09:48:40 GMT

Example of a time calculation:

DATA: diff      TYPE i,
      seconds TYPE i,
      hours   TYPE i.

DATA: t1 TYPE t VALUE '200000',
      t2 TYPE t VALUE '020000'.

diff = t2 - t1.
seconds = diff MOD 86400.
hours = seconds / 3600.

The number of hours between 02:00:00 and 20:00:00 is calculated.

· First, the difference between the time fields is calculated. This is -64800, since t1 is converted internally to 72000 and t2 to 7200.

· Then, with the operation MOD, this negative difference is converted to the total number of seconds. A positive difference would be unaffected by this calculation.

· Third, the number of hours is calculated by dividing the number of seconds by 3600.

The last three lines can be replaced by the following line

HOURS = ( ( t2 - t1) MOD 86400) / 3600.

Re: TIME

Former Member — Mon, 19 Feb 2007 09:51:13 GMT

u dont need a fm i think try this

data: time1 type sy-uzeit value '102030'.

data: time2 type sy-uzeit value '102530'.

time2 = time2 - time1.

write: time2.

santhosh

Re: TIME

Former Member — Mon, 19 Feb 2007 09:52:36 GMT

Hi Vijay,

Try FM <b>SALP_SM_CALC_TIME_DIFFERENCE</b>

reward if useful.

Re: TIME

Former Member — Mon, 19 Feb 2007 09:55:31 GMT

Hi,

Use this FM:

/SDF/CMO_TIME_DIFF_GET

Regards

Shiva

Re: TIME

Former Member — Mon, 19 Feb 2007 10:20:07 GMT

Thanks Chandrasekar. I rewarded points to you and I have one more doubt. That is what is the use of " Earliest " parameter.

Thanks.

Re: TIME

Former Member — Mon, 19 Feb 2007 10:27:10 GMT

Vijay,

Earliest parameter tells you which one of the entered DATE TIME is greater. If the DATE1 TIME1 is greater than the DATE2 TIME2 it is set to '1'. Else it is '2'. If both are same it is set to '0'.

Thanks

Re: TIME

Former Member — Mon, 19 Feb 2007 10:37:00 GMT

Hi vijay,

Earliest can have the values 0 , 1 and 2

If both the dates are equal , then it is 0

if date1 > date 2 , earliest is 2

if date2 > date1 , earliest is 1