topic Re: function module to convert to time stamp format in Application Development and Automation Discussions

function module to convert to time stamp format

Former Member — Wed, 10 Jan 2007 02:57:29 GMT

Hi friends,

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

kind regards.

Re: function module to convert to time stamp format

raja_thangamani — Wed, 10 Jan 2007 03:02:26 GMT

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

Re: function module to convert to time stamp format

Former Member — Wed, 10 Jan 2007 03:13:45 GMT

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

Re: function module to convert to time stamp format

satykumar — Wed, 10 Jan 2007 03:18:39 GMT

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

Re: function module to convert to time stamp format

raja_thangamani — Wed, 10 Jan 2007 03:24:41 GMT

Look at this link

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

Raja T

Re: function module to convert to time stamp format

Former Member — Wed, 10 Jan 2007 03:58:11 GMT

Hi,

Try these FMs;

LXHME_TIMESTAMP_CONVERT_INTO

ABI_TIMESTAMP_CONVERT_INTO

hope this will help you

Thanks

Shiva

Re: function module to convert to time stamp format

kishorekumar_vemula — Thu, 25 Jan 2007 10:59:53 GMT

you can use this fm

CMS_DATE_TO_TIMESTAMP

regds,

Kish