C # Format and usage of the current time given by datetime

DateTime.Now.ToShortTimeString () 
DateTime dt = DateTime.Now; 
Dt. ToString ();//2005-11-5 13:21:25 
Dt. Tofiletime (). ToString ();//127756416859912816 
Dt. TOFILETIMEUTC (). ToString ();//127756704859912816 
Dt. ToLocalTime (). ToString ();//2005-11-5 21:21:25 
Dt. Tolongdatestring (). ToString ();//November 5, 2005 
Dt. Tolongtimestring (). ToString ();//13:21:25 
Dt. ToOADate (). ToString ();//38661.5565508218 
Dt. ToShortDateString (). ToString ();//2005-11-5 
Dt. Toshorttimestring (). ToString ();//13:21 
Dt. ToUniversalTime (). ToString ();//2005-11-5 5:21:25 
Dt. Year.tostring ();//2005 
Dt. Date.tostring ();//2005-11-5 0:00:00 
Dt. Dayofweek.tostring ();//saturday 
Dt. Dayofyear.tostring ();//309 
Dt. Hour.tostring ();//13 
Dt.Millisecond.ToString ();//441 
Dt. Minute.tostring ();//30 
Dt. Month.tostring ();//11 
Dt. Second.tostring ();//28 
Dt. Ticks.tostring ();//632667942284412864 
Dt. Timeofday.tostring ();//13:30:28.4412864 
Dt. ToString ();//2005-11-5 13:47:04 
Dt. AddYears (1). ToString ();//2006-11-5 13:47:04 
Dt. AddDays (1.1). ToString ();//2005-11-6 16:11:04 
Dt. AddHours (1.1). ToString ();//2005-11-5 14:53:04 
Dt. Addmilliseconds (1.1). ToString ();//2005-11-5 13:47:04 
Dt. AddMonths (1). ToString ();//2005-12-5 13:47:04 
Dt. AddSeconds (1.1). ToString ();//2005-11-5 13:47:05 
Dt. AddMinutes (1.1). ToString ();//2005-11-5 13:48:10 
Dt. Addticks (1000). ToString ();//2005-11-5 13:47:04 
Dt.compareto (DT). ToString ();//0 
Dt. ADD (?). ToString ();//question mark is a time period 
Dt. Equals ("2005-11-6 16:11:04"). ToString ();//false 
Dt. Equals (DT). ToString ();//true 
Dt. GetHashCode (). ToString ();//1474088234 
Dt. GetType (). ToString ();//system.datetime 
Dt. GetTypeCode (). ToString ();//datetime

Dt. Getdatetimeformats (' s ') [0]. ToString ();//2005-11-05t14:06:25 
Dt. Getdatetimeformats (' t ') [0]. ToString ();//14:06 
Dt. Getdatetimeformats (' y ') [0]. ToString ();//November 2005 
Dt. Getdatetimeformats (' D ') [0]. ToString ();//November 5, 2005 
Dt. Getdatetimeformats (' D ') [1]. ToString ();//2005 11 05 
Dt. Getdatetimeformats (' D ') [2]. ToString ();//Saturday 2005 11 05 
Dt. Getdatetimeformats (' D ') [3]. ToString ();//Saturday November 5, 2005 
Dt. Getdatetimeformats (' M ') [0]. ToString ();//November 5 
Dt. Getdatetimeformats (' f ') [0]. ToString ();//November 5, 2005 14:06 
Dt. Getdatetimeformats (' g ') [0]. ToString ();//2005-11-5 14:06 
Dt. Getdatetimeformats (' R ') [0]. ToString ();//sat, 2005 14:06:25 GMT 
String. Format ("{0:d}", DT);//2005-11-5 
String. Format ("{0}", dt);//November 5, 2005 
String. Format ("{0:f}", dt);//November 5, 2005 14:23 
String. Format ("{0:f}", dt);//November 5, 2005 14:23:23 
String. Format ("{0:g}", DT);//2005-11-5 14:23 
String. Format ("{0:g}", DT);//2005-11-5 14:23:23 
String. Format ("{0:m}", dt);//November 5 
String. Format ("{0:r}", DT);//sat, 2005 14:23:23 GMT 
String. Format ("{0:s}", DT);//2005-11-05t14:23:23 
String. Format ("{0:t}", DT);//14:23 
String. Format ("{0:t}", DT);//14:23:23 
String. Format ("{0:u}", DT);//2005-11-05 14:23:23z 
String. Format ("{0:u}", dt);//November 5, 2005 6:23:23 
String. Format ("{0:y}", dt);//November 2005 
String. Format ("{0}", dt);//2005-11-5 14:23:23 
String. Format ("{0:yyyymmddhhmmssffff}", DT); 
Calculates the difference in the number of days between 2 dates 
----------------------------------------------- 
DateTime dt1 = Convert.datetime ("2007-8-1"); 
DateTime DT2 = Convert.datetime ("2007-8-15"); 
TimeSpan span = dt2. Subtract (DT1); 
int Daydiff = span. Days + 1; 
Calculate the number of days of the month in a year 
----------------------------------------------- 
int days = Datetime.daysinmonth (2007, 8); 
days = 31; 
Add one day to date, one day less 
----------------------------------------------- 
DateTime DT =datetime.now; 
Dt. AddDays (1); Add one day 
Dt. AddDays (-1);//Decrease One day 
Other years method similar ... 
Convert Date function in Oracle sql 
----------------------------------------------- 
To_date ("2007-6-6", "yyyy-mm-dd"); 
To_date ("2007/6/6", "yyyy/mm/dd"); 
For the next set of data, how to find a table that contains September records: 
Cggc_stratdate cggc_enddate 
========================================= 
2007-8-4 2007-9-5 
2007-9-5 2007-9-20 
2007-9-22 2007-10-5 
SELECT * from TABLE 
(To_date (' 2007/9/1 ', ' yyyy/mm/dd ') between cggc_stratdate 
and Cggc_enddate OR cggc_stratdate >=to_date (' 2007/9/1 ', ' yyyy/mm/dd ') 
and Cggc_enddate<=to_date (' 2007/9/30 ', ' yyyy/mm/dd ') " 
OR to_date (' 2007/9/30 ', ' yyyy/mm/dd ') between cggc_stratdate 
and Cggc_enddate) ORDER by Cggc_stratdate ASC 

//this year, Formatting with ToString character we also easily calculate the first and last day of the year
DateTime.Parse (DateTime.Now.ToString ("yyyy-01-01")). ToShortDateString ();
DateTime.Parse (DateTime.Now.ToString ("yyyy-01-01")). AddYears (1). AddDays (-1). ToShortDateString ();
//Last year, no more explaining
DateTime.Parse (DateTime.Now.ToString ("yyyy-01-01")). AddYears (-1). ToShortDateString ();
DateTime.Parse (DateTime.Now.ToString ("yyyy-01-01")). AddDays (-1). ToShortDateString ();
//Next year
DateTime.Parse (DateTime.Now.ToString ("yyyy-01-01")). AddYears (1). ToShortDateString ();
DateTime.Parse (DateTime.Now.ToString ("yyyy-01-01")). AddYears (2). AddDays (-1). ToShortDateString ();

//this quarter, a lot of people will find this difficult, You need to write a long process to judge. In fact, we all know that four quarters a year, three months a quarter
//First we push the date to the first month of the quarter, and then the first day of the month is the first day of the quarter.
DateTime.Now.AddMonths (0-( DATETIME.NOW.MONTH-1) (% 3)). ToString ("yyyy-mm-01");
//In the same vein, the last day of the quarter is the first day of the next quarter minus one
DateTime.Parse (DateTime.Now.AddMonths (3-((datetime.now.month-1)% 3)). ToString ("yyyy-mm-01")). AddDays (-1). ToShortDateString ();
//Next quarter
DateTime.Now.AddMonths (3-((datetime.now.month-1)% 3)). ToString ("yyyy-mm-01");
DateTime.Parse (DateTime.Now.AddMonths (6-((datetime.now.month-1)% 3)). ToString ("yyyy-mm-01")). AddDays (-1). ToShortDateString ();
//Last quarter
DateTime.Now.AddMonths ( -3-((datetime.now.month-1)% 3)). ToString ("yyyy-mm-01");
DateTime.Parse (DateTime.Now.AddMonths (0-((datetime.now.month-1)% 3)). ToString ("yyyy-mm-01")). AddDays (-1). ToShortDateString ();

How to get how many days a month

int M=system.datetime.daysinmonth (system.datetime.now.year,system.datetime.now.month);

Get the actual working day of a month (that is, excluding week 6th)

Call
int days =getdays (System.DateTime.Now));
private int getDays (System.DateTime date1)
{
int M=system.datetime.daysinmonth (date1. Year,date1. Month);
int mm=0;
for (int i=1;i<=m;i++)
{
System.DateTime Date=convert.todatetime (date1. year+ "-" +date1. month+ "-" +i);
Switch (date. DayOfWeek)
{
Case System.DayOfWeek.Monday:
Case System.DayOfWeek.Thursday:
Case System.DayOfWeek.Tuesday:
Case System.DayOfWeek.Wednesday:
Case System.DayOfWeek.Friday:
mm=mm+1;
Break

}                
}
return mm;
}

Obtain a valid working day between any two dates (excluding week 6th) to obtain a valid working day between any two dates (excluding week 6th) #region Get a valid working day between any two dates (excluding weeks 6th)

Call
DateTime date1=convert.todatetime ("2005-10-20");
DateTime date2=convert.todatetime ("2005-11-01");
int days =getdays (DATE1,DATE2);
private int getDays (System.DateTime date1,system.datetime date2)
{
String M=datediff (Enumdatecompare.day,date1,date2). ToString ("F0");
 
int mm=0;
for (int i=0;i<=convert.toint32 (m); i++)
{
System.DateTime Date=convert.todatetime (date1. AddDays (i));
Switch (date. DayOfWeek)
{
Case System.DayOfWeek.Monday:
Case System.DayOfWeek.Thursday:
Case System.DayOfWeek.Tuesday:
Case System.DayOfWeek.Wednesday:
Case System.DayOfWeek.Friday:
mm=mm+1;
Break
} 
}
return mm;
}
#endregion
Format output

Format Output #region format output
private void Page_Load (object sender, System.EventArgs e)
{
System.Globalization.DateTimeFormatInfo Mydtfi = new System.Globalization.CultureInfo ("en-us", false). DateTimeFormat;
China with ZH-CN
DateTime myDT =system.datetime.now;
Response.Write (Mydt.tostring ("F", Mydtfi));
/**//**//**//*
This code produces the following output.
FORMAT en-US EXAMPLE
CHAR VALUE of associated property, IF any
D 1/3/2002 m/d/yyyy (ShortDatePattern)
D Thursday, January, 2002 dddd, MMMM DD, yyyy (LONGDATEPATTERN)
F Thursday, January, 2002
F Thursday, January, 2002 12:00:00 AM dddd, MMMM dd, yyyy h:mm:ss TT (Fulldatetimepattern)
G 1/3/2002 AM
G 1/3/2002 12:00:00 AM
M January MMMM DD (Monthdaypattern)
M January MMMM DD (Monthdaypattern)
R Thu, Jan 2002 00:00:00 GMT ddd, dd MMM yyyy HH ': ' mm ': ' SS ' GMT ' (Rfc1123pattern)
R Thu, Jan 2002 00:00:00 GMT ddd, dd MMM yyyy HH ': ' mm ': ' SS ' GMT ' (Rfc1123pattern)
s 2002-01-03t00:00:00 yyyy '-' mm '-' dd ' T ' HH ': ' mm ': ' SS (Sortabledatetimepattern)
T-h:mm TT (Shorttimepattern)
T 12:00:00 AM h:mm:ss tt (Longtimepattern)
U 2002-01-03 00:00:00z yyyy '-' mm '-' dd HH ': ' mm ': ' SS ' Z ' (Universalsortabledatetimepattern)
U Thursday, January, 2002 8:00:00 AM
Y January, 2002 MMMM, YYYY (Yearmonthpattern)
Y January, 2002 MMMM, YYYY (Yearmonthpattern)
*/
}
#endregion

Get this week's Saturday and Sunday

Convertdatetoweek#region Convertdatetoweek
public static void Convertdatetoweek (DateTime date,out datetime firstdate,out datetime lastdate)
{
DateTime First=system.datetime.now;
DateTime Last=system.datetime.now;
Switch (date. DayOfWeek)
{Case System.DayOfWeek.Monday:
First=date. AddDays (-1);
Last=date. AddDays (5);
Break
Case System.DayOfWeek.Tuesday:
First=date. AddDays (-2);
Last=date. AddDays (4);
Break
Case System.DayOfWeek.Wednesday:
First=date. AddDays (-3);
Last=date. AddDays (3);
Break
Case System.DayOfWeek.Thursday:
First=date. AddDays (-4);
Last=date. AddDays (2);
Break
Case System.DayOfWeek.Friday:
First=date. AddDays (-5);
Last=date. AddDays (1);
Break
Case System.DayOfWeek.Saturday:
First=date. AddDays (-6);
Last=date;
Break
Case System.DayOfWeek.Sunday:
First=date;
Last=date. AddDays (6);
Break
}
Firstdate=first;
Lastdate=last;
}
#endregion
Call
DateTime Firstdate=system.datetime.now;
DateTime Lastdate=system.datetime.now;
Convertdatetoweek (date,out firstdate,out lastdate);
Get the current date is the week of the year
DateTime dt = Convert.todatetime ("2006-05-01");
int weeks = dt. DAYOFYEAR/7 + 1;

C # Format and usage of the current time given by datetime