I want the reason why C# date is bigger than SQL Date even if C# code is running first and after that SQL query,

Logically the SQL date should be greater than C# date.

For your reference the .NET application and SQL Server are on my local machine.

C# Code:

using System.Data;
using System.Data.SqlClient;

for (int i = 1; i <= 20; i++)
{
    AddRecord();
}
Console.WriteLine("200 records added in database....");

void AddRecord()
{
    try
    {
        string ConnectionString = @"data source=OM5SQL2019; database=TestDb; integrated security=SSPI";
        using (SqlConnection connection = new SqlConnection(ConnectionString))
        {
            SqlCommand cmd = new SqlCommand()
            {
                CommandText = "SP_AddRecord",
                Connection = connection,
                CommandType = CommandType.StoredProcedure
            };

            DateTime date = DateTime.UtcNow;
            SqlParameter param1 = new SqlParameter
            {
                ParameterName = "@ReceivedOn",
                SqlDbType = SqlDbType.DateTime,
                Value = date,
                Direction = ParameterDirection.Input
            };
            cmd.Parameters.Add(param1);

            connection.Open();
            cmd.ExecuteNonQuery();
        }
    }
    catch (Exception ex)
    {
        Console.WriteLine($"Exception Occurred: {ex.Message}");
    }
}

SQL Procedure:

CREATE OR ALTER   PROCEDURE [dbo].[SP_AddRecord]
@ReceivedOn datetime
AS
BEGIN
    SET NOCOUNT ON;

     insert into Records(CreateDate,ReceivedOnDate) values
     (GETUTCDATE(),@ReceivedOn)

END

Result in table

I have tried many methods

• In C# – DateTime.Now & SQL – GETDATE()
• In C# – DateTime.Now & SQL – SYSDATETIME()
• In C# – DateTime.UTCNow & SQL – GETUTCDATE()
• In C# – DateTime.UTCNow & SQL – SYSUTCDATETIME()

Also changed column type from datetime to datetime2, varchar(max).

I want an actual reason or an authentic source which can explain this.