06-26-2007 7:49 PM
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.
06-26-2007 8:02 PM
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
06-26-2007 8:20 PM
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.
06-26-2007 8:25 PM
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
07-13-2007 2:40 AM