Azure Data Studio - SELECT Results datetimeoffset format

[zengouu]

Running a basic SELECT * FROM MyTable results show a datetimeoffset format based on my OS regional settings. For example, time separator in my country/region is a baseline dot ( . ) and Azure Data Studio query shows it as is.

This poses a problem when I'm manually copying datetimeoffset values from SELECT to a UPDATE clause, as UPDATING datetimeoffset column requires me to use colon symbol ( : ) as a separator.

Is there an OS-independent way to define how azure data studio shows the results?

Same in pictures:
What I get now:

What I would like to get:

My workaround now is to define my OS region to be something different than what it actually is, which is hacky.

OS: MacOS Sonoma 14.0
Azure Data Studio: 1.46.1

[cheenamalhotra]

Hi @zengouu

Have you tried exporting results to any format? Does that export results in correct format for you?