MSSQL: datetimeoffset column values should show timezone if value is in UTC (+00:00) Follow
Answered
The timezone information should always appear even if it is UTC; this also helps to identify the data type of the column. Currently, if a value of type datetimeoffset has an offset of +00:00 (UTC), this information is not shown in the table:
This also becomes a problem because if data is exported in text format (e.g. CSV) the timezone information is omitted if it's +00:00, and any import to another datetimeoffset column using these files will fail with the following message:
conversion failed: "2019-10-08 10:35:27.2379930" to datetimeoffset
I'm running Datagrip 2020.2.2 and this issue happens with both latest drivers of MSSQL Server and Azure SQL Database.
Please sign in to leave a comment.
Jon Franco,
Thank you for feedback. Follow an issue https://youtrack.jetbrains.com/issue/DBE-11071 to track progress.