C # calculate the number of days between two dates

Source: Internet
Author: User

In SQL, select datediff ("DD", joindatetime, getdate () from DB

So what about C #?

// Use timespan in C # To calculate the difference between the two time points
// You can add any time unit between two dates.
Private string datediff (datetime datetime1, datetime datetime2)
{String datediff = NULL;
Timespan ts1 = new timespan (datetime1.ticks );
Timespan ts2 = new timespan (datetime2.ticks );
Timespan Ts = ts1.subtract (ts2). duration ();
Datediff = ts. days. tostring () + "day" + ts. hours. tostring () + "Hour" + ts. minutes. tostring () + "Minute" + ts. seconds. tostring () + "seconds ";
Return datediff;
}

Timespan Ts = date1-date2;
Double ddays = ts. totaldays; // Number of days with decimals. For example, if one day is 12 hours, 1.5 is returned.
Int ndays = ts. Days; // Integer Number of days. The result is 1 for 12 hours per day or 20 hours per day.

/// <Summary>
/// Calculate the interval between two dates
/// </Summary>
/// <Param name = "datetime1"> first date and time </param>
/// <Param name = "datetime2"> Second Date and time </param>
/// <Returns> </returns>
Private string datediff (datetime datetime1, datetime datetime2)
{
String datediff = NULL;

Timespan ts1 = new timespan (datetime1.ticks );
Timespan ts2 = new timespan (datetime2.ticks );
Timespan Ts = ts1.subtract (ts2). duration ();
Datediff = ts. Days. tostring () + "day"
+ Ts. Hours. tostring () + "hour"
+ Ts. Minutes. tostring () + "Minute"
+ Ts. Seconds. tostring () + "seconds ";

Return datediff;
}

Note:
1. The datetime Value Type represents a specific date time between 00:00:00 on January 1, January 1, 0001 AD and on January 1, December 31, 9999 AD. Therefore, you can use the datetime value type to describe any time within the expected range. A datetime value represents a specific time.
2. the timespan value contains many attributes and methods for accessing or processing a timespan value.
The following list covers some of them:
Add: adds the value to another timespan value.
Days: returns the timespan value calculated by the number of days.
Duration: gets the absolute value of timespan.
Hours: returns the hourly timespan value.
Milliseconds: returns the timespan value in milliseconds.
Minutes: returns the timespan value calculated in minutes.
Negate: returns the opposite number of the current instance.
Seconds: returns the timespan value calculated in seconds.
Subtract: Subtract another timespan value from it.
Ticks: the number of tick values returned for timespan.
Totaldays: returns the number of days indicated by the timespan value.
Totalhours: returns the number of hours represented by the timespan value.
Totalmilliseconds: the number of milliseconds in which the timespan value is returned.
Totalminutes: returns the number of minutes represented by the timespan value.
Totalseconds: returns the number of seconds represented by the timespan value.

///


// Date comparison
///
/// current date
// input date
// compare days
// returns true if the number of days is greater, false
private bool comparedate (string today, string writedate, int N)
{< br> datetime today = convert. todatetime (today);
datetime writedate = convert. todatetime (writedate);
writedate = writedate. adddays (n);
If (today> = writedate)
return false;
else
return true;

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.