{"id":638,"date":"2010-06-14T18:18:00","date_gmt":"2010-06-14T10:18:00","guid":{"rendered":"http:\/\/blog.jixin.ntxz.net\/?p=638"},"modified":"2010-07-30T15:38:50","modified_gmt":"2010-07-30T07:38:50","slug":"net-%e6%9c%80%e5%85%a8%e7%9a%84%e6%97%b6%e9%97%b4%e6%a0%bc%e5%bc%8f%e8%bd%ac%e6%8d%a2","status":"publish","type":"post","link":"http:\/\/www.ntxz.net\/?p=638","title":{"rendered":".net \u6700\u5168\u7684\u65f6\u95f4\u683c\u5f0f\u8f6c\u6362"},"content":{"rendered":"

.net\u65e5\u671f\u683c\u5f0f\u8f6c\u6362<\/p>\n

DateTime dt = DateTime.Now;<\/p>\n

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();\/\/2005\u5e7411\u67085\u65e5
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();\/\/\u95ee\u53f7\u4e3a\u4e00\u4e2a\u65f6\u95f4\u6bb5
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();\/\/2005\u5e7411\u6708
dt.GetDateTimeFormats(‘D’)[0].ToString();\/\/2005\u5e7411\u67085\u65e5
dt.GetDateTimeFormats(‘D’)[1].ToString();\/\/2005 11 05
dt.GetDateTimeFormats(‘D’)[2].ToString();\/\/\u661f\u671f\u516d 2005 11 05
dt.GetDateTimeFormats(‘D’)[3].ToString();\/\/\u661f\u671f\u516d 2005\u5e7411\u67085\u65e5
dt.GetDateTimeFormats(‘M’)[0].ToString();\/\/11\u67085\u65e5
dt.GetDateTimeFormats(‘f’)[0].ToString();\/\/2005\u5e7411\u67085\u65e5 14:06
dt.GetDateTimeFormats(‘g’)[0].ToString();\/\/2005-11-5 14:06
dt.GetDateTimeFormats(‘r’)[0].ToString();\/\/Sat, 05 Nov 2005 14:06:25 GMT<\/p>\n

string.Format(“{0:d}”,dt);\/\/2005-11-5
string.Format(“{0:D}”,dt);\/\/2005\u5e7411\u67085\u65e5
string.Format(“{0:f}”,dt);\/\/2005\u5e7411\u67085\u65e5 14:23
string.Format(“{0:F}”,dt);\/\/2005\u5e7411\u67085\u65e5 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);\/\/11\u67085\u65e5
string.Format(“{0:R}”,dt);\/\/Sat, 05 Nov 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);\/\/2005\u5e7411\u67085\u65e5 6:23:23
string.Format(“{0:Y}”,dt);\/\/2005\u5e7411\u6708
string.Format(“{0}”,dt);\/\/2005-11-5 14:23:23
string.Format(“{0:yyyyMMddHHmmssffff}”,dt);<\/p>\n

\u8ba1\u7b972\u4e2a\u65e5\u671f\u4e4b\u95f4\u7684\u5929\u6570\u5dee
———————————————–
DateTime dt1 = Convert.DateTime(“2007-8-1”);
DateTime dt2 = Convert.DateTime(“2007-8-15”);
TimeSpan span = dt2.Subtract(dt1);
int dayDiff = span.Days + 1;                   <\/p>\n

\u8ba1\u7b97\u67d0\u5e74\u67d0\u6708\u7684\u5929\u6570
———————————————–
int days = DateTime.DaysInMonth(2007, 8);
days = 31;                                     <\/p>\n

\u7ed9\u65e5\u671f\u589e\u52a0\u4e00\u5929\u3001\u51cf\u5c11\u4e00\u5929
———————————————–
DateTime dt =DateTime.Now;
dt.AddDays(1); \/\/\u589e\u52a0\u4e00\u5929
dt.AddDays(-1);\/\/\u51cf\u5c11\u4e00\u5929
\u5176\u5b83\u5e74\u4efd\u65b9\u6cd5\u7c7b\u4f3c…<\/p>\n

Oracle SQL\u91cc\u8f6c\u6362\u65e5\u671f\u51fd\u6570
———————————————–
to_date(“2007-6-6″,’YYYY-MM-DD”);
to_date(“2007\/6\/6″,’yyyy\/mm\/dd”);<\/p>\n

\u5982\u4e0b\u4e00\u7ec4\u6570\u636e,\u5982\u4f55\u67e5\u627e\u8868\u91cc\u5305\u542b9\u6708\u4efd\u7684\u8bb0\u5f55:
CGGC_STRATDATE CGGC_ENDDATE
=========================================
2007-8-4 2007-9-5
2007-9-5 2007-9-20
2007-9-22 2007-10-5<\/p>\n

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<\/p>\n","protected":false},"excerpt":{"rendered":"

.net\u65e5\u671f\u683c\u5f0f\u8f6c\u6362 DateTime dt = DateTime.Now; dt.ToString();\/\/ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,8],"tags":[],"class_list":["post-638","post","type-post","status-publish","format-standard","hentry","category-1","category-oldblog"],"views":287,"_links":{"self":[{"href":"http:\/\/www.ntxz.net\/index.php?rest_route=\/wp\/v2\/posts\/638","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.ntxz.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.ntxz.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.ntxz.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.ntxz.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=638"}],"version-history":[{"count":1,"href":"http:\/\/www.ntxz.net\/index.php?rest_route=\/wp\/v2\/posts\/638\/revisions"}],"predecessor-version":[{"id":754,"href":"http:\/\/www.ntxz.net\/index.php?rest_route=\/wp\/v2\/posts\/638\/revisions\/754"}],"wp:attachment":[{"href":"http:\/\/www.ntxz.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.ntxz.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=638"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.ntxz.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}