Can't translated set.GroupBy(x=>x.Time.Year)

[Cricle]

File a bug

Include your code

 set.GroupBy(x=>x.Time.Year).ToQueryString()

Include stack traces

No

Include verbose output

System.InvalidOperationException:“The LINQ expression 'DbSet<TestData>()
    .GroupBy(x => x.Time.Year)' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.”

Include provider and version information

EF Core version:
Database provider: (Microsoft.EntityFrameworkCore.Sqlite)
Target framework: (.NET 6.0)
Operating system:
IDE: (e.g. Visual Studio 2022 17.3.3)

[ajcvickers]

@Cricle What is the type of the Time property?

[Cricle]

@Cricle What is the type of the Time property?

DateTime type

EF Core Version is 6.0.4/6.0.10

[ajcvickers]

Duplicate of #19929.