Re: Daylight Saving Time Biztalk problems

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Daylight Saving Time Biztalk problems › Re: Daylight Saving Time Biztalk problems

April 21, 2008 at 9:20 AM #19415
community-content

    That is definitely odd. Because we dont seem to have issues. The only thing we faced was the week after the DST move forward in March ; when we used HAT to query the previous weeks orchestrations we noticed timing issues..in the way it was reported.

     This we realized was caused by @UtcOffsetMin which is used in queries which calculates the offset by using getdate 

    1

    *DateDiff(“mi”,CONVERT(varchar,GetDate(),0),CONVERT(varchar,GetUTCDate(),0))