So I have a SQL Server database where one table includes two columns, ‘StartTime’ and ‘EndTime’ which are both ‘DateTime’ type columns. I fully tested it, and wherever I viewed the query, everything looked fine.
…that is, until I went to site.
We pulled up the Perspective view with the table that displays the values, and noticed that the client’s computer was showing times that consistently had a 34 minute offset compared to what it should be. Unless I’m missing something, this totally blows my mind trying to figure out what’s going on.
We tried both computers (his and mine) with both Chrome and Edge, with no different results at all.
When I view the entries in SSMS or the Designer’s query browser, it shows
1900-01-01 07:00:00 and
1900-01-01 18:30:00 respectively (we’re only using the time value, not the date). It gets formatted in the Perspective table using the column format parameter as
HH:mm and shows
18:30. When I view it on the client’s computer (correction: TWO computers), it shows
17:56 respectively. I could totally understand a timezone correction (which I’ve checked), … but 34 minutes?? Seriously??
Anyone have any ideas where to look?