topic Re: DATE & TIME in Application Development and Automation Discussions

DATE & TIME

sivakrishna_boddapati — Tue, 23 Feb 2010 03:50:03 GMT

hI experts

i have one field created_at it contains data '20091005221011' i want to split that data into two parts like 20091005 and '2210111'

how?

Re: DATE & TIME

GauthamV — Tue, 23 Feb 2010 04:02:06 GMT

Use proper subject line in future.

Just split them like this into 2 variables.

Date = created_at +0(8).

Time = created_at +8(6).


Total Posts:  16  
Total Questions:  8 (8 unresolved)

Note: Plz close your threads once they are resolved.

Re: DATE & TIME

Former Member — Tue, 23 Feb 2010 04:03:06 GMT

Hi Siva,

Have a look at the following statement,

CONVERT TIME STAMP tst

TIME ZONE tz

INTO DATE d

TIME t DAYLIGHT SAVING TIME dst.

For more infor, read the below blog ...

/people/himanshu.gupta/blog/2006/11/14/abap4-date-time-and-timestamps

Also have a look at this FM

'CIF_GEN_CONVERT_TIMESTAMP'.

Regards,

Abhijit G. Borkar

Re: DATE & TIME

Former Member — Tue, 23 Feb 2010 04:04:06 GMT

Hi,

V_datetime = '20091005221011' .

vdate = v_datetime+0(8).

vtime = v_datetime+9(7).

Try this, this will solve ur problem

Rani.

Re: DATE & TIME

venkat_o — Tue, 23 Feb 2010 04:05:08 GMT

Hello, Try this way.


report ztest.
data:
      date_time type c LENGTH 14 VALUE '20091005221011',
      date      TYPE sy-datum,
      time      TYPE sy-uzeit.

date = date_time+0(8).
time = date_time+8(6).

WRITE date.
WRITE:/ time.

Thanks Venkat.O

Re: DATE & TIME

Former Member — Tue, 23 Feb 2010 04:06:20 GMT

Hi,

You can simply use offset method to split it as date will always contain 8 characters and further will be date.

Thanks,

Archana

Re: DATE & TIME

sivakrishna_boddapati — Mon, 08 Mar 2010 09:47:11 GMT

thank u