data type datetime is displayed as gibberish

[f8dca]

MSSQL datetime data 2023-06-06 00:00:00.000 shows as ��

[lovasoa]

What is the exact mssql type of the datetime you are selecting ? (precise type, size, and scale)

SQL Server has many datetime types

You can find that out using SQL_VARIANT_PROPERTY

[f8dca]

The mssql data type was datetime

select count(*) as Y, cast(invoice_date as datetime) as X
from AMTV2.SPIRE_SALES_HISTORY_ITEMS
group by  invoice_date

[lovasoa]

Okay. I implemented support for datetime in the latest sqlx-oldapi. But datetime is deprecated, you should use datetime2 or datetimeoffset.

[lovasoa]

Okay, the bug was actually in SQLPage. Working on it!

[lovasoa]

I updated the title because the issue was not specific to mssql. It'll be fixed in the next version.

[lovasoa]

Fixed in https://github.com/lovasoa/SQLpage/releases/tag/v0.9.2