topic Re: date conversion in Application Development and Automation Discussions

date conversion

madan_ullasa — Thu, 09 Nov 2006 23:04:13 GMT

hi frnds,

i want to convert a date field to type f..i could do that.. but the same value in database in table ausp is different.

ATFLV = 2.006103100000000E07 in ausp table.. it has 8 "0's" between 1 and E... but when i convert sy-datum to type f it comes as 2.0061028000000000E07.... that is 9 "0's" between 8 and E... why is that ?

Points assured to all replies..

Regards,

Madan..

Re: date conversion

Clemenss — Fri, 10 Nov 2006 00:08:39 GMT

Hi,

the only difference is the accuracy. The number of trailing zeros does not change the value of a type F variable at all.

Possibly one is with and the other without sign allowing one more decimal.

Don't worry 2.006102800000000E+07 =

2.0061028000000000E+07 =

20061028

The only difference is the representation.

Better try GET TIMESTAMP concept.

Regards,

Clemens