topic Re: TIME STAMP in Application Development and Automation Discussions

TIME STAMP

Former Member — Thu, 03 Nov 2005 08:41:54 GMT

Program:

CONVERT TIME STAMP gs_test-timestamp_from

TIME ZONE 'UTC'

INTO DATE gv_price_date TIME gv_price_time.

Wrong message:

The line type of "GS_TEST-TIMESTAMP_FROM" must be compatible

Anybody how knows what I should do?

Re: TIME STAMP

Former Member — Thu, 03 Nov 2005 08:46:40 GMT

hi,

gs_test-timestamp_from must be type timestamp

look at this example

DATA:

tstamp type timestamp,

d TYPE D VALUE '19971224',

t TYPE T VALUE '235500'.

SET COUNTRY 'US'.

CONVERT DATE d TIME t INTO

TIME STAMP tstamp TIME ZONE 'UTC+12'.

" tstamp : 19971224115500

" (12/24/1997 11:55:00)

CONVERT TIME STAMP tstamp TIME ZONE 'UTC+12' INTO

DATE d TIME t.

cheers,

sasi

Re: TIME STAMP

Former Member — Thu, 03 Nov 2005 08:47:11 GMT

I got this from help:

CONVERT - Converting Timestamps

CONVERT - Converting Timestamps

              Variants:
              1. CONVERT TIME STAMP tst TIME ZONE tz INTO DATE d TIME t.
              2. CONVERT DATE d TIME t INTO TIME STAMP tst TIME ZONE tz.

Effect        Converts the timestamp tst into date d or time t based on the
              time zone tz.

              tst must have the type P(8) (short form) or P(11) with 7
              decimal places (long form). tz must have the type C(6). The
              ABAP Dictionary contains the data elements TIMESTAMP,
              TIMESTAMPL, and TIMEZONE, which you can use in DATA ... TYPE
              ... statements to declare tst and tz. There are no strict type
              checks for the date d or time t. If you specify a variable
              that does not have type T, the system uses the type conversion
              rules applied in the MOVE statement.

As mentioned above, the data type of GS_TEST-TIMESTAMP_FROM should be p.

Sudha