Why DateTime overflow error in SQL Server
From my search page I am passing start date and end date to sql server.
when user provides any start and end date, every thing works smooth.
When user is not providing anything then I am sending DateTime.MinValue and DateTime.MaxValue for start date and end date respectively and getting error of overflow.
StartDate = DateTime.MinValue ;
EndDate = DateTime.MaxValue;
Why it's giving overflow error?
2
|
Asked:
06 Mar 2013
Reputation: 47
|
|
1 Answer
C# minimum and maximum values are out of SQL Server minimun and maximum values
- C# Minimum value: 1/1/0001 12:00:00 AM
-
C# Maximum value: 12/31/9999 11:59:59 PM
-
SQL Server Minimum value: 1/1/1753 12:00:00 AM
So your C# minimum value is out of sql server minimum value, that's why you are getting overflow error.
|
3
|
Answered:
06 Mar 2013
Reputation: 242
|
|
This week users
