Bug description

SQL by EFCore:

SELECT COUNT(*)
FROM [Foo] AS [f]
WHERE GETDATE() > '2026-01-01T00:00:00.0000000'

this is not a valid date format string

[22007] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]THE DATE, TIME, OR TIMESTAMP VALUE IS INVALID.

Your code

using var dbContext = new MyDbContext();
var set = dbContext.Set<Foo>();
var count = set.Where(x => DateTime.Now > new DateTime(2026, 1, 1)).Count();

Stack traces

Verbose output

EF Core version

9.0.0

Database provider

No response

Target framework

No response

Operating system

No response

IDE

No response