topic Re: Convert TimeStamp? in Application Development and Automation Discussions

Convert TimeStamp?

Former Member — Tue, 26 Jun 2007 18:49:24 GMT

Hi Guys,

Can anybody tell me how to convert Time Stamp Filed into Time Format?

I donnot know what is Time Stamp Field?Can anybody explain me and tell how to convert?

Thanks,

Gopi.

Re: Convert TimeStamp?

ferry_lianto — Tue, 26 Jun 2007 19:02:25 GMT

Hi,

Please check this weblog perhaps it may help.

/people/horst.keller/blog/2004/11/29/abap-geek-8-150-summertime-blues-133

Regards,

Ferry Lianto

Re: Convert TimeStamp?

Former Member — Tue, 26 Jun 2007 19:20:06 GMT

Hi Ferry,

In COEP table there is a filed called TIMESTMP and the value is like this 5,206,199,010,000.How to intepret and convert this.

But the link which u send and the format of that explained TIMESTAMP is YYYYMMDDHHMMSS.

can u explain me how to solve this becoz i think both are not same?

Thanks,

Gopi.

Re: Convert TimeStamp?

ferry_lianto — Tue, 26 Jun 2007 19:25:19 GMT

Hi,

Please try this FM RKE_TIMESTAMP_CONVERT_OUTPUT (Convert GMT to local time/date).


  ...
  
  move COEP-TIMESTMP to timestmp.
  
  CALL FUNCTION 'RKE_TIMESTAMP_CONVERT_OUTPUT'
       EXPORTING i_dayst    = sy-dayst
                 i_tzone    = sy-tzone
                 i_timestmp = timestmp
       IMPORTING e_date     = wa_date
                 e_time     = wa_time.


  write: / wa_date, wa_time.

Regards,

Ferry Lianto

Re: Convert TimeStamp?

Former Member — Fri, 13 Jul 2007 01:40:51 GMT

It is work!

Thank you Ferry Lianto