C # get current time and sync time

Source: Internet
Author: User

http://blog.163.com/[email protected]/blog/static/549639712010112921658843/we can get the current time by using the Datatime class. We can get different times by invoking various methods in the class: Date (2008-09-04), Time (12:12:12), date + time (2008-09-04 12:11:10), etc.


Get Date + Time
DateTime.Now.ToString (); 2008-9-4 20:02:10
DateTime.Now.ToLocalTime ().        ToString (); 2008-9-4 20:12:12

Get Date
DateTime.Now.ToLongDateString ().    ToString (); September 4, 2008
DateTime.Now.ToShortDateString ().    ToString (); 2008-9-4
DateTime.Now.ToString ("Yyyy-mm-dd"); 2008-09-04
DateTime.Now.Date.ToString (); 2008-9-4 0:00:00

Get time
DateTime.Now.ToLongTimeString ().   ToString (); 20:16:16
DateTime.Now.ToShortTimeString ().   ToString (); 20:16
DateTime.Now.ToString ("Hh:mm:ss"); 08:05:57
DateTime.Now.TimeOfDay.ToString (); 20:33:50.7187500

Other
Datetime.tofiletime ().       ToString (); 128650040212500000
DATETIME.NOW.TOFILETIMEUTC ().   ToString (); 128650040772968750
DateTime.Now.ToOADate ().       ToString (); 39695.8461709606
DateTime.Now.ToUniversalTime ().   ToString (); 2008-9-4 12:19:14

DateTime.Now.Year.ToString (); Get year//2008
DateTime.Now.Month.ToString (); Get Month//9
DateTime.Now.DayOfWeek.ToString (); Get Week//Thursday
DateTime.Now.DayOfYear.ToString (); Get the day of the Week//248
DateTime.Now.Hour.ToString (); Get hours//20
DateTime.Now.Minute.ToString (); Get minutes//31
DateTime.Now.Second.ToString (); Gets the number of seconds//45

N is a number, can be a number of integers, can also matter a decimal
Dt. AddYears (n).   ToString (); Time Plus n years
Dt. AddDays (n).   ToString (); Plus n days
Dt. AddHours (n).   ToString (); Add N Hours
Dt. AddMonths (n).   ToString (); Add n months
Dt. AddSeconds (n).   ToString (); Plus n seconds
Dt. AddMinutes (n).   ToString (); Add n Points


SQL statements use time and date functions


GETDATE (): Gets the current time of the system
DATEADD (datepart,number,date): Calculates a new time value after a time based on a time, such as: DateAdd (Yy,30,getdate ())
DateDiff (datepart,startdate,enddate): Calculates the difference of two time, such as: DateDiff (Yy,getdate (), ' 2008-08-08 ')
Dataname (datepart,date): Gets the value of a different part of time, the return value is a string
DatePart (datepart,date): Similar to Datename, except that the return value is integer type
Day: Gets the number of days of the specified time
Month (date): Gets the month of the specified time
Year (date): Gets the years of the specified time

Select year (GETDATE ()): Current Years

Sync Time:

Http://www.jb51.net/article/65365.htm

C # get current time and sync time

Related Article

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.