topic Re: Time Format in Application Development and Automation Discussions

Time Format

Former Member — Mon, 28 Nov 2005 14:02:09 GMT

Hi Every one ,

Could any one say me how could i convert the time format

for ex: i am getting a .txt file and the time defined is

09:57 and internally system is taking as <b>9::57</b>

Regards.

Re: Time Format

Former Member — Mon, 28 Nov 2005 14:06:39 GMT

Hi,

The time format is hhmmss.

Svetlin

Re: Time Format

Former Member — Mon, 28 Nov 2005 14:14:45 GMT

yes at my database level i have taken data type as TIM of 6 char but when i am uploading data from a .txt file system is also taking ':' as a charecter and storing as

Re: Time Format

RichHeilman — Mon, 28 Nov 2005 14:20:02 GMT

Here is some code.



report zrich_0001.

data: time_from_file(10) type c value '9:57'.
data: internal_time type sy-uzeit.


data: hours(2) type c.
data: minutes(2) type c.

split time_from_file at ':' into hours minutes.

if hours < 10.
  shift hours right deleting trailing space.
  hours+0(1) = 0.
endif.

concatenate hours minutes '00' into internal_time.


write:/ internal_time.

Regards,

Rich Heilman

Re: Time Format

andreas_mann3 — Mon, 28 Nov 2005 14:27:40 GMT

ot try that:

DATA time TYPE sy-uzeit.
DATA time4(4).
DATA txt(10).
txt = '9::57'.

WHILE txt CA ':'.
  REPLACE ':' WITH space INTO txt.
ENDWHILE.
CONDENSE txt NO-GAPS.
UNPACK txt TO time4.
MOVE time4 TO time.

Andreas

Re: Time Format

Former Member — Mon, 28 Nov 2005 14:34:48 GMT

Hi Andreas,

Thanks i have done this way

REPLACE ':' WITH '' INTO str_if-begzt.

CONDENSE str_if-begzt NO-GAPS.

but now i have one more problem i have a field that gives me a total time i am a bit confused wat data type should i declare at Dictionary ...

luk at the record

total begtime endtime

0.98 08:59 09:58

Regards

Re: Time Format

andreas_mann3 — Mon, 28 Nov 2005 14:50:55 GMT

Hi,

use a variable type p decimals 2 for total (qty)

e.g. : TISTD

unit = hours

Andreas