How to check date is valid for Sql server or not?

I needed to check the date is valid for sql server or not before i pass it to Sql server so i did it using below code and it’s working fine…

static bool IsValidSqlDateTimeNative(string someval)
bool valid = false;
DateTime testDate = DateTime.MinValue;
System.Data.SqlTypes.SqlDateTime sdt;
if (DateTime.TryParse(someval, out testDate))
// take advantage of the native conversion
sdt = new System.Data.SqlTypes.SqlDateTime(testDate);
valid = true;
catch (System.Data.SqlTypes.SqlTypeException ex)

// no need to do anything, this is the expected out of range error

return valid;


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: