topic Re: TimeStamp conversion in Application Development and Automation Discussions

TimeStamp conversion

prasad_reddy9 — Tue, 03 Jul 2007 05:58:04 GMT

I am convertind date and time into timestamp and I am getting the timestamp as following 19,991,101,143,146.

I want the timestamp in yyyy-mm-dd hh:mm:ss format.

Help.

Re: TimeStamp conversion

Former Member — Tue, 03 Jul 2007 06:08:03 GMT

Hi,

you can use the function module MA_CNV_TIMESTAMP_IN_GMTTSTAMP

Thanks.

Re: TimeStamp conversion

Clemenss — Tue, 03 Jul 2007 06:41:00 GMT

Hi Prasad,

19,991,101,143,146 looks like a SAP standard timestamp. It could be recognized in various locations/Modules of various SAP systems around the universe.

If you want a human-readable timestamp like yyyy-mm-dd hh:mm:ss you can define it as a string or char field lenght 18. Use a simple statement to get this:


concatenate 
  date(2) '-'
  date+4(2) '-'
  date+6(2) ` `
  time(2) ':'
  time+2(2) ':'
  timr+4(2) 
  into timestamp

date is a field of type sy-datum, time is type sy-uzeit. The space between date and time is encloded in back quotes: ` not '.

Regards,

Clemens

Re: TimeStamp conversion

Former Member — Tue, 03 Jul 2007 06:46:22 GMT

Hi,

date = timestamp+0(8)

time = timestamp+8(6).

else try this way

convert time stamp wa_rseqdone_ts

time zone sy-zonlo

into date wa_ts_date

time wa_ts_time.

check this link for full details

http://www.bwexpertonline.com/downloads/DBConnectMakingDELTAABAPCode.doc

Regards,

Sudheer