In the below code, DateTime.Now is translated to GETDATE() and DateTime.UtcNow is translated to GETUTCDATE() - these functions return SQL Server's datetime.

Should they use equivalent functions that return datetime2 instead? These are SYSDATETIME() and SYSUTCDATETIME() respectively. The precision and range of datetime2 is a closer (exact?) match to .NET DateTime so it feels like the more faithful translation, but I'm not sure if there are legacy reasons to use the older functions.

I can submit a PR to fix this if it's considered a valid proposal.