Repository: dotnet/efcore
File: src/EFCore.SqlServer/Query/Internal/Translators/SqlServerDateTimeMemberTranslator.cs (C#)

Code before:
                    nullable: true,
                    argumentsPropagateNullability: Statics.FalseTrue,
                    returnType,
                    declaringType == typeof(DateTime)
                        ? instance!.TypeMapping
                        : typeMappingSource.FindMapping(typeof(DateTime))),

            nameof(DateTime.TimeOfDay)
                => sqlExpressionFactory.Function(
                    "CONVERT",
                    [sqlExpressionFactory.Fragment("time"), instance!],
                    nullable: true,
                    argumentsPropagateNullability: Statics.FalseTrue,
                    returnType),

            nameof(DateTime.Now)
                when declaringType == typeof(DateTime)
                => sqlExpressionFactory.Function(
                    "GETDATE",
                    arguments: [],
                    nullable: false,
                    argumentsPropagateNullability: [],
                    returnType,
                    typeMappingSource.FindMapping(typeof(DateTime), "datetime")),

            nameof(DateTime.Now)
                when declaringType == typeof(DateTimeOffset)
                => sqlExpressionFactory.Function(
                    "SYSDATETIMEOFFSET",
                    arguments: [],
                    nullable: false,
                    argumentsPropagateNullability: [],
                    returnType),

            nameof(DateTime.UtcNow)
                when declaringType == typeof(DateTime)
                => sqlExpressionFactory.Function(
                    "GETUTCDATE",
                    arguments: [],
                    nullable: false,
                    argumentsPropagateNullability: [],
                    returnType,
                    typeMappingSource.FindMapping(typeof(DateTime), "datetime")),

            nameof(DateTime.UtcNow)
                when declaringType == typeof(DateTimeOffset)
                => sqlExpressionFactory.Convert(
                    sqlExpressionFactory.Function(
                        "SYSUTCDATETIME",
                        arguments: [],
                        nullable: false,

Review comment (suggestion):
nit:
 
```suggestion
            nameof(DateTimeOffset.Now)
```

Same below for DateTimeOffset.UtcNow

Code after:
                    nullable: true,
                    argumentsPropagateNullability: Statics.FalseTrue,
                    returnType,
                    declaringType == typeof(DateTime)
                        ? instance!.TypeMapping
                        : typeMappingSource.FindMapping(typeof(DateTime))),

            nameof(DateTime.TimeOfDay)
                => sqlExpressionFactory.Function(
                    "CONVERT",
                    [sqlExpressionFactory.Fragment("time"), instance!],
                    nullable: true,
                    argumentsPropagateNullability: Statics.FalseTrue,
                    returnType),

            nameof(DateTime.Now)
                when declaringType == typeof(DateTime)
                => sqlExpressionFactory.Function(
                    "GETDATE",
                    arguments: [],
                    nullable: false,
                    argumentsPropagateNullability: [],
                    typeof(DateTime),
                    typeMappingSource.FindMapping("datetime")),

            nameof(DateTimeOffset.Now)
                when declaringType == typeof(DateTimeOffset)
                => sqlExpressionFactory.Function(
                    "SYSDATETIMEOFFSET",
                    arguments: [],
                    nullable: false,
                    argumentsPropagateNullability: [],
                    typeof(DateTimeOffset),
                    typeMappingSource.FindMapping("datetimeoffset")),

            nameof(DateTime.UtcNow)
                when declaringType == typeof(DateTime)
                => sqlExpressionFactory.Function(
                    "GETUTCDATE",
                    arguments: [],
                    nullable: false,
                    argumentsPropagateNullability: [],
                    typeof(DateTime),
                    typeMappingSource.FindMapping("datetime")),

            nameof(DateTimeOffset.UtcNow)
                when declaringType == typeof(DateTimeOffset)
                => sqlExpressionFactory.Convert(
                    sqlExpressionFactory.Function(
                        "SYSUTCDATETIME",
                        arguments: [],