Converting Local time to different time Zone

[Former Member]

We came across this problem especially when we have different Data sources which each of them might be using different time Zone.

I do not find any function which allow MII to convert a DateTime to a specific DateTime of a timezone

For example

System A - TimeZone GMT + 0 hour (01:00:00)

MII server - TimeZone GMT + 2 hours (03:00:00)

I need to send local DateTim of MII to system A. But this local DateTime in MII must be converted to GMT + 0 hour. Meaning instead of send 03:00:00, I should send 01:00:00 . It does not make sense to do do 03:00:00 - 2 hours as there will be Sommer time and Winter Time issue. As sommer time is - 1 hour and winter time is -2 hours

Any idea?

[Former Member · Accepted solution]

Seng,

The only place that I am aware of that takes care of the Time zone are the Virtual Servers with the parameter TZOffset but this won't help with your case as you are directly dealing with the Data sources.

Here's a link http://help.sap.com/saphelp_xmii115/helpdata/en/index.htm this'll help you determine the Time zone of the MII server.

Now if you are looking to convert then have you looked at the possibility of converting at the data source layer rather than MII?

I mean if its a SQl or Oracle DB you are dealing with then maybe there's some function in PL/SQL that'll help you in the conversion.

Just a thought, hope it helps.

Thanks

Udayan

[Former Member · Accepted solution]

Hi Udayan

YOur link sends me to the index. Is there particular Help page describing this issue?