topic Re: Function module for date and time conversion in SRGBTBREL table in Application Development and Automation Discussions

Function module for date and time conversion in SRGBTBREL table

Former Member — Tue, 16 Apr 2013 03:52:35 GMT

Hi All ,

I have field UTCTIME in table SRGBTBREL .

in Selection screen i'm entering date and time depending on selection criteria it should display value in grid .

in table date and time is stored as 20,130,205,055,431 format .

can any one tell me how to convert date(YYYYMMDD) and time(HH:MM:SEC) from selection screen to above format mentioned in table .

Re: Function module for date and time conversion in SRGBTBREL table

Former Member — Tue, 16 Apr 2013 04:21:34 GMT

Hello,

Use FM : IB_CONVERT_INTO_TIMESTAMP

Re: Function module for date and time conversion in SRGBTBREL table

Rushikesh_Yeole — Tue, 16 Apr 2013 04:26:34 GMT

You can use FM OIL_DATE_TO_TIMESTAMP. Just pass date and time. It will give ypou time stamp in reuired format.

Re: Function module for date and time conversion in SRGBTBREL table

Former Member — Tue, 16 Apr 2013 04:47:04 GMT

Hi Smitha,

Try the following code:

DATA: time_stamp TYPE timestamp,
      dat TYPE d,
      tim TYPE t,
      tz TYPE ttzz-tzone.

tz = 'INDIA'. "Time Zone
dat = '20030309'. "Date
tim = '013000'.   "Time

CONVERT DATE dat TIME tim
INTO TIME STAMP time_stamp TIME ZONE tz.