Source: stackoverflow.com --- Sunday, October 15, 2017
i was running an app using local SQL hosting provider and everything was working fine (hosted in Australia). I then decided to move MS Azure with an Australian region subscription. There is now a very odd bug playing up and I cant work out which setting in MS Azure is causing it. Basically: I use a drag and drop feature for my roster (drag and drop shifts on a specific day) If I drag a shift to a specific date, once you drop the shift it appears on the day before in my calendar The app always thinks that the date is the day before The application works on my local before publishing. It was working under my old hosting provider After I migrated to Azure and publish, the issue shows on my live site (but not my local) To make it more complicated, I actually connected my localhost to the MS Azure database directly to test - IT WORKS! The issue only shows after publish. It feels like it has to do with the regional settings on MS Azure and given that Australia is many hours ahead of the rest of the world, it feels like it is picking up the US time or the server time (which will almost always be the day before). In Azure, my SQL server is hosted in east coast Australia as shown on my Azure dashboard. Anyone experienced anything like this before? ...
from Australia http://ift.tt/2hGIQ9F
No comments:
Post a Comment