Datetime2 displayed differently on 2 computers

59 Views Asked by At

I have a problem while using DATETIME2 (SQL Server). The display is not the same on two computers with similar configuration (Windows Server 2012).

When I do a simple SELECT, the first computer display "2021-10-13 09:50:00" but the second one display "2021-10-13 09:50:00.9070000".

It doesn't seem related to my database (it's literally the same database and the same data). I think it's related to my computer's configuration but I don't know what could be different? Is there a way to configure the date format on Microsoft SQL Server Native Client or somewhere else?

Thanks a lot for your help.

0

There are 0 best solutions below