07-03-2007 6:58 AM
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.
07-03-2007 7:08 AM
Hi,
you can use the function module MA_CNV_TIMESTAMP_IN_GMTTSTAMP
Thanks.
07-03-2007 7:08 AM
Hi,
you can use the function module MA_CNV_TIMESTAMP_IN_GMTTSTAMP
Thanks.
07-03-2007 7:41 AM
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
07-03-2007 7:46 AM
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