date time checking in c#.net

Question

User1432265183 posted

this is minimum and maximum date in ms sql - January 1, 1753, through December 31, 9999

I want to check this in c#.net code. Is there any efficient way to check ?

Answer 1

User1428336426 posted

DateTime minDate = DateTime.MaxValue; 

DateTime maxDate = DateTime.MinValue;

Answer 2

User-18289217 posted

Response.Write("Minimum " + DateTime.MinValue.ToLongDateString() + "<br />" + "Maximum " + DateTime.MaxValue.ToLongDateString());

to check a certain date if it's in the given range you can do the following:

 if (tobechecked > DateTime.MinValue && tobechecked < DateTime.MaxValue)
            {
                // Do Something
            }
            else
            {
                // Do Something
            }

Answer 3

User1432265183 posted

this will give minDate as 1/1/0001 12:00:00 AM ..

But in ms sql, it won't allow this for the datatype datetime..

for ms sql - I've mentioned the minimum value...

Answer 4

User1432265183 posted

DateTime minDate = DateTime.MaxValue;

DateTime maxDate = DateTime.MinValue;

In c#.net, minDate will give as 1/1/0001 12:00:00 AM ..

In Ms sql min and max date will be for datetime type January 1, 1753, through December 31, 9999..

Ms sql won't allow less than that min value and greater than that maximum value.

Answer 5

User-2001332922 posted

Vague to say that SqlClient in Ado.net object that must be one looking for.

Answer 6

User281315223 posted

You can actually check the minimum available DateTime within SQL using the SqlDateTime.MinValue property and SqlDateTime.MaxValue respectively : 

using System.Data.SqlTypes;

protected void Page_Load(object sender, EventArgs e)
{
      //If a PostBack occurred
      if(IsPostBack)
      {
             //Check if your Date is valid against the SqlRange
            if (YourDateTime >= SqlDateTime.MinValue && YourDateTime <= SqlDateTime.MaxValue)
            {

            }
      }
}

Answer 7

User-18289217 posted

In that case you may want to check against

System.Data.SqlTypes.SqlDateTime.MinValue

Answer 8

User1432265183 posted

You can actually check the minimum available DateTime within SQL using the 
SqlDateTime.MinValue property and 
SqlDateTime.MaxValue respectively : 
using System.Data.SqlTypes;

protected void Page_Load(object sender, EventArgs e)
{
      //If a PostBack occurred
      if(IsPostBack)
      {
             //Check if your Date is valid against the SqlRange
            if (YourDateTime >= SqlDateTime.MinValue && YourDateTime <= SqlDateTime.MaxValue)
            {

            }
      }
}

Cannot check C#.net date time to sqlDateTime...

Answer 9

User281315223 posted

Oops.

I was quite sure that the above would work (as I am not noticing any syntax issues on my machine), you may actually need to access the Value property of the SqlDateTime object to perform the comparison : 

//The Value property actually yields a DateTime object that can be used for comparisons
SqlDateTime.MinValue.Value

so for a more complete example : 

using System.Data.SqlTypes;

protected void Page_Load(object sender, EventArgs e)
{
      //If a PostBack occurred
      if(IsPostBack)
      {
             //Check if your Date is valid against the SqlRange
            if (YourDateTime >= SqlDateTime.MinValue.Value && YourDateTime <= SqlDateTime.MaxValue.Value)
            {

            }
      }
}

Answer 10

User-18289217 posted

Not necessarily ... the following code works just fine without using Value:

DateTime tobechecked = DateTime.Now;
if (tobechecked > SqlDateTime.MinValue && tobechecked < SqlDateTime.MaxValue)
            {
                Response.Write("It's in the MSSQL dates range!!!");
            }
            else {
                Response.Write("It's NOT in the MSSQL dates range!!!");
            }

Answer 11

User1432265183 posted

Oops.
I was quite sure that the above would work (as I am not noticing any syntax issues on my machine), you may actually need to access the Value property of the SqlDateTime object to perform the comparison : 
//The Value property actually yields a DateTime object that can be used for comparisons
SqlDateTime.MinValue.Value

so for a more complete example : 

using System.Data.SqlTypes; protected void Page_Load(object sender, EventArgs e) { //If a PostBack occurred if(IsPostBack) { //Check if your Date is valid against the SqlRange if (YourDateTime >= SqlDateTime.MinValue.Value && YourDateTime <= SqlDateTime.MaxValue.Value) { } } }

Thank you. Great.