Skip to Content
0
Former Member
Jun 08, 2011 at 07:41 AM

Converting Local time to different time Zone

421 Views

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?