topic Re: Convert numeric data to timestamp in Application Development and Automation Discussions

Convert numeric data to timestamp

Former Member — Mon, 13 Jul 2009 05:23:21 GMT

i want two variables with data type timestamp and numc3 . the content of the first variable is 12:30:00. and the content of the second variable is 022. It is basically in minutes. when i add up the two it gives the output as 12:30:22. which is wrong . i want to convert this numeric data to timestamp. is there any function module to do that. can any one help me ?

Re: Convert numeric data to timestamp

faisalatsap — Mon, 13 Jul 2009 05:33:44 GMT

Hi,

Test the bellow Sample Code it will solve out your problem,

DATA: time LIKE sy-uzeit,
      min TYPE i,
      sec TYPE i.

time = sy-uzeit.
min = 50.       " Total Min
sec = 50 * 60.  " Convert Min to Sec

ADD: sec TO time.
WRITE: time.

Best Regards,

Faisal

Re: Convert numeric data to timestamp

saumya_govil — Mon, 13 Jul 2009 05:36:47 GMT

Hi Kallol,

Multiply numc3 with 60 (convert min to sec) before adding to timestamp.

Hope this helps!

Regards,

Saumya

Re: Convert numeric data to timestamp

Former Member — Mon, 13 Jul 2009 05:42:27 GMT

convert ur minutes to TIME format

e.g

convert minutes to secs


    seconds = 22 * 60.

Now convert to time format


      add_time+0(2) = seconds / 3600. "Hours
      seconds = seconds mod 3600.
      add_time+2(2) = seconds / 60.   "Minutes
      seconds = seconds mod 60.
      add_time+4(2) = seconds.         "Seconds

now use FM CONV_UTIL_ADD_DATE_AND_TIME to add time to timestamp


      CALL FUNCTION 'CONV_UTIL_ADD_DATE_AND_TIME'
           EXPORTING
                in_timestamp  = cur_tm_stmp
*                add_days      = days
                add_time      = add_time
           IMPORTING
                out_timestamp = cur_tm_stmp.

Re: Convert numeric data to timestamp

Former Member — Mon, 13 Jul 2009 05:42:27 GMT

it has solved my problem . thanks