topic Re: TIME format conversion in Application Development and Automation Discussions

TIME format conversion

Former Member — Wed, 25 Jun 2008 13:48:00 GMT

Please help me out

I have data

Input = 2.00+e4 ( Exponential Form)

i want out put = 20:00:00 ( time format)

how to do this? any function module ???

regards

aryan

Re: TIME format conversion

Former Member — Wed, 25 Jun 2008 13:53:56 GMT

Hello,

If you know exactly how it'll always come in - why not use string manipulation?

Kind regards

Ash Thomas

Sap Consultants

www.ashpeople.com

Re: TIME format conversion

Former Member — Wed, 25 Jun 2008 13:58:55 GMT

Make a type as sy-uzeit Amit.

Re: TIME format conversion

Former Member — Wed, 25 Jun 2008 14:07:48 GMT

if i give

input 4.00+e4

what will be desired output

can explain it more

with Example

Cheers

Snehi

Re: TIME format conversion

former_member195383 — Wed, 25 Jun 2008 14:11:04 GMT

This message was moderated.

Re: TIME format conversion

Former Member — Wed, 25 Jun 2008 14:24:38 GMT

I just want to know that

If you check CAWN table ther time format is storing as Float ...and i have to fetch the same field in TIME format

I don't know how....

STRING manupulation i can't do in 2000+e4 format...

any solution...

Re: TIME format conversion

Former Member — Wed, 25 Jun 2008 14:27:09 GMT

Hi,

When we assign a floating point number to a field of type T

then the floating point number is converted into Packed number (As no. of Seconds) and then the Packed number is converted to time format(HH:MM:SS).

data:

w_float type f,

w_time like sy-uzeit.

w_float = '2.00+e4' .

w_time = w_float.

write w_time.

output :

00:00:02.

I think this will help you