Loading

Face datetime error.

Rohan

4y783SQL

Hello everyone I have sent DateTime from the ajax call. But I have face a issue.

SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. I have sent this data.ModifiedOn = "2022-08-16 11:40:55.000";

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vishal Joshi4y ago
In case to pass DateTime to SQL need to pass parameter with DateTime type as below.
SqlParameter parameter = command.Parameters.Add("@dt",
System.Data.SqlDbType.DateTime);
Also, you can use the DateTime type parameter on the server side to get the value.