function module to convert to time stamp format

[Former Member]

Hi friends,

can you tell me any function module to convert date and time to time stamp format?

kind regards.

[raja_thangamani]

Just use

CONVERT DATE d 
TIME t [DAYLIGHT SAVING TIME dst] 
INTO TIME STAMP tst 
TIME ZONE tz.

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. 

Also look at the blog..

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

Raja T

Message was edited by:

Raja Thangamani

[Former Member]

hi raja!

thank you for your response.

if i want to convert to eastern standard time, i shud write 'utc-6' instead of utc+12?

regards

[raja_thangamani]

Look at this link

http://tycho.usno.navy.mil/zones.html

Raja T

[Former Member]

Hi,

Try these FMs;

LXHME_TIMESTAMP_CONVERT_INTO

ABI_TIMESTAMP_CONVERT_INTO

hope this will help you

Thanks

Shiva

[satykumar]

Hi,

Try any one of thease

data x type t value '002900'.

data w type sy-uzeit value '002900'.

write (8) x using edit mask '__:__:__'.

write w.

Thanks,

Satyendra

[kishorekumar_vemula]

you can use this fm

CMS_DATE_TO_TIMESTAMP

regds,

Kish