topic convert date to timestamp in Application Development and Automation Discussions

convert date to timestamp

Former Member — Fri, 04 Apr 2008 11:33:47 GMT

hi,

I'm converting an spread sheet to internal table using FM 'ALSM .........' my problem is I'm getting date from the excell sheet but before storing it into internal table i want to convert the date into timestamp.

regards,

santosh

Re: convert date to timestamp

Former Member — Fri, 04 Apr 2008 11:36:50 GMT

hi,

Try this FM.

RKE_TIMESTAMP_CONVERT_INPUT – Converts display to TIMESTAMP fields

\[removed by moderator\]

Edited by: Jan Stallkamp on Jul 24, 2008 12:41 PM

Re: convert date to timestamp

Former Member — Fri, 04 Apr 2008 11:41:47 GMT

Hi,

Please use FM CIF_GEN3_CONVERT_DATETIME.

Thanks,

Sriram Ponna.

Re: convert date to timestamp

Former Member — Fri, 04 Apr 2008 11:49:32 GMT

hi,

FRE_MASTER_OUT F&R CON R/3 Master Data

Functions

FRE_CONVERT_DATE_TO_TIMESTMP Convert Date to Timestamp

FRE_ORDER_IN F&R CON R/3 - Purchasing

Functions

FRE_CONVERT_DATE_2_TIMESTAMP Converts Date into Timestamp (15)

FRE_CONVERT_TIMESTAMP_2_DATE Converts Timestamp (15) into Date

Regards,

Brown.

Re: convert date to timestamp

Former Member — Fri, 04 Apr 2008 12:01:50 GMT

Please see if the "CONVERT" operator does what you want. There is a pretty good help page on it. Here is a small extract from it.

CONVERT DATE

Syntax

CONVERT DATE dat [TIME tim [DAYLIGHT SAVING TIME dst]]

INTO TIME STAMP time_stamp TIME ZONE tz.

Re: convert date to timestamp

Former Member — Fri, 04 Apr 2008 12:05:53 GMT

Hi Santosh,

also check this from other thread

REPORT YCHATEST MESSAGE-ID ZZ .

data: str type string.

concatenate sy-datum sy-uzeit ',' '0000000' into str.

write:/ str.

Re: convert date to timestamp

Former Member — Thu, 29 Jan 2009 11:29:23 GMT

bjbhb