It has come to light that we are suffering from this long standing issue of dates and times being recorded in the database an hour out when we are on UK summer time.
This subsequently put all of our reports out since we use MS Reporting Services and query the database directly. I have no intention of re-writing the reports to account for the 6 month time change.
Is it possible to always have ITBM record the dates and times in the correct time zone? In our case, always UK time, and never anything else.
This is quite an urgent matter for us, so if anyone has any suggestions I would be really grateful.
To give some background aruond what has already been done:
- All users have the correct timezone in ITBM
- The SQL user is set to British English
- All reports are set to en-GB