Queries on Microsoft SQL Azure (RTM) Drivers Datetimeoffset doesn't include timeoffset e.g. +07:00 in the end

[thmlbdshoichi]

Please answer the questions below, it helps us to track the issue.

1. Which driver are you using and version of it (Ex: PostgreSQL 10.0):

   • Microsoft SQL Azure (RTM)

2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81):

   • TablePlus 5.9.7 Build 272 x64

3. The steps to reproduce this issue:

   • Query any data from the table that has a column which has data type of datetimeoffset
   • the date result is not included timeoffset
   • Example: 2024-04-09 13:13:59.6240825 should be 2024-04-09 13:13:59.6240825 +07:00
   • this behavior is also led to the incorrect of using gui update since the data is not include time offset,
   • If you update the data to 2024-04-09 13:13:59.6240825 +07:00 and the next query will still not include +07:00 in the end

Noted: If the bug is related to data, please attach an example SQL data.

It doesn't have time offset

There is the structure of this table which type is datetimeoffset

If Update using Tableplus GUI need to include +07:00 in the end to specify time offset which is normal behavior

then If Query the same record the timeoffset +07:00 is gone