Method One: Convert.todatetime (String)
String format is required and must be YYYY-MM-DD HH:MM:SS
================================================
Method Two: Convert.todatetime (String, IFormatProvider)
DateTime DT;
DateTimeFormatInfo Dtformat = new System.globalizationdatetimeformatinfo ();
Dtformat.shortdatepattern = "YYYY/MM/DD";
DT = Convert.todatetime ("2011/05/26", Dtformat);
================================================
Method Two: DateTime.ParseExact ()
String datestring = "20110526";
DateTime dt = DateTime.ParseExact (datestring, "YyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
Or
DateTime dt = DateTime.ParseExact (datestring, "YyyyMMdd", System.Globalization.CultureInfo.InvariantCulture);
Attached reference information:
CultureInfo CultureInfo = cultureinfo.createspecificculture ("en-us");
string format = "ddd MMM d HH:mm:ss zz00 yyyy";
String stringvalue = DateTime.Now.ToString (format, cultureInfo); Get date string
datetime = DateTime.ParseExact ("Wed Aug 16:28:03 +0800", format, cultureInfo);//convert String to own Period
Other
Date format: YyyyMMdd HH:mm:ss (Note that the letter case of this string is very strict)
YYYY: Representing the year
MM: Represents month
DD: Representative Day
HH: On behalf of the hour (24-hour system)
MM: On behalf of minutes
SS: On behalf of the second
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, Nov 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, Nov-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 number of days difference 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 a month in a year
-----------------------------------------------
int days = Datetime.daysinmonth (2007, 8);
days = 31;
Add a day to the date and reduce the day
-----------------------------------------------
DateTime DT =datetime.now;
Dt. AddDays (1); Add a day
Dt. AddDays (-1);//Reduce one day
Other year methods are similar ...
Convert date functions in Oracle SQL
-----------------------------------------------
To_date ("2007-6-6", ' Yyyy-mm-dd ");
To_date ("2007/6/6", ' Yyyy/mm/dd ");