topic TimeStamp Conversion issues in Application Development and Automation Discussions

TimeStamp Conversion issues

Former Member — Thu, 09 Dec 2010 06:10:08 GMT

Hi,

I am using the below code for converting date and time to timestamp.

To convert time of a zone into GMT time in the form of time stamp

CONVERT DATE p_dat_low TIME p_v_times DAYLIGHT SAVING TIME p_v_dst

INTO TIME STAMP p_v_tst TIME ZONE p_p_t_zone.

in timezone I am passing 'LBANON' i,e for country lebanon. But i am getting error i,e sy-subrc = 12.

Can anyone plz help me how to rectify this

Thanks,

Sakti

Re: TimeStamp Conversion issues

former_member242255 — Thu, 09 Dec 2010 06:26:33 GMT

You can use the Fm 'IB_CONVERT_INTO_TIMESTAMP'

Re: TimeStamp Conversion issues

sridhar_meesala — Thu, 09 Dec 2010 06:28:52 GMT

Hi,

Try uing the FM VELO03_CONVERT_INTO_TIMESTAMP to convert to timestamp.

Thanks,

Sri.

Re: TimeStamp Conversion issues

Former Member — Thu, 09 Dec 2010 06:43:24 GMT

Hi Sravan,

Thanks for your response.

But in this FM there is no parameter to pass 'daylight saving'.

Thanks,

Sakti

Re: TimeStamp Conversion issues

Former Member — Fri, 10 Dec 2010 06:50:24 GMT

Hi,

I have written the below code.

CONVERT DATE p_dat_low TIME p_v_times DAYLIGHT SAVING TIME p_v_dst

INTO TIME STAMP p_v_tst TIME ZONE p_p_t_zone.

For some countries it is working for some it is not working.

Can anyone suggest where is the problem.

Thanks,

Sakti

Re: TimeStamp Conversion issues

Former Member — Fri, 10 Dec 2010 07:01:16 GMT

Have you checked the documentation.......


CONVERT DATE dat [TIME tim [DAYLIGHT SAVING TIME dst]] 
        INTO TIME STAMP time_stamp TIME ZONE tz.


Sy-Subrc = 12: Time specification could not be converted, because dat, tim, or dst contain invalid or inconsistent values. 
If dst has a different value or the specified value does not suit the value in tim and dat, the time_stamp remains unchanged and sy-subrc is set to 12

Re: TimeStamp Conversion issues

Former Member — Fri, 10 Dec 2010 07:24:32 GMT

Hi Satyajit,

Thanks for your response.

I am totally agree with you.

can you explain me more details about the issues as i have already mentioned the same syntax working for some countries and not for other.

e;g for Lebanon it is not working. Because i am passing 'LBANON' in timezone . As lebanon is 2 hrs ahead from UTC time, if i passed 'UTC2' in timezone it is working.

Thanks,

Sakti