Datetime formatting on MSSQL

[thomax]

I'm running Adminer in a docker container, connecting to a MSSQL database. Out of the box, datetime fields (which Adminer reports as datetimeoffset) are rendered in the Adminer UI as May 9 2025 10:43:27:6732500AM.

My question is: How can I configure Adminer to render this on ISO-8601 format, e.g. 2025-05-09T10:43:27:67325Z?

My environment is: Adminer v5.2.1, Firefox v138.0.1, MacOS v15.5 on arm64.

[vrana]

I couldn't reproduce it. datetimeoffset is displayed as 2025-05-30 13:37:48 for me.

https://learn.microsoft.com/en-us/sql/t-sql/data-types/datetimeoffset-transact-sql mentions something about SET LANGUAGE and SET DATEFORMAT, can you try changing them and selecting the data in SQL command?

[thomax]

Thanks for following up! I've tried other DB managers (e.g. SQLTools) which show datetimes as expected.

Anyway, I've decided to scrap mssql, and moved all my data to postgresql. This will make it difficult for me to debug the issue. Thus, feel free to close this issue as "can't reproduce" :)