topic Re: Function module for converting German Data/Time to Indian Date/Time in Application Development and Automation Discussions

Function module for converting German Data/Time to Indian Date/Time

Former Member — Wed, 13 Sep 2006 10:18:51 GMT

Dear All,

My requirement is to convert German date and time to Indian date and time. Is there any function module available or any way we can get it?

Thanks and regards,

Atanu

Re: Function module for converting German Data/Time to Indian Date/Time

Former Member — Wed, 13 Sep 2006 10:24:13 GMT

hi,

 first get the timezone of that country

CALL FUNCTION 'TZON_LOCATION_TIMEZONE'
      EXPORTING
        if_country        = p_it_userid-zcountry
      IMPORTING
        ef_timezone       = l_tzone
      EXCEPTIONS
        no_timezone_found = 1
        OTHERS            = 2.

then use the below statements

-- Convert from server time to GMT
      CLEAR l_tstmp.
      CONVERT DATE l_datum
              TIME l_ctime
         INTO TIME STAMP l_tstmp TIME ZONE sy-zonlo.

*-- Convert from GMT to user backup time
      CONVERT TIME STAMP l_tstmp TIME ZONE it_usr_timezone-ztzone
        INTO DATE it_usr_timezone-zdate
             TIME it_usr_timezone-ztime.

Re: Function module for converting German Data/Time to Indian Date/Time

Former Member — Wed, 13 Sep 2006 10:25:29 GMT

you can use CONVERT TIME STAMP

CONVERT TIME STAMP tst TIME ZONE tz INTO DATE d TIME t.

CONVERT DATE d TIME t INTO TIME STAMP tst TIME ZONE tz.