{"id":2922,"date":"2013-11-18T04:00:03","date_gmt":"2013-11-18T04:00:03","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2922"},"modified":"2013-11-18T04:22:03","modified_gmt":"2013-11-18T04:22:03","slug":"%e6%8c%89%e6%9c%88%e7%bb%9f%e8%ae%a1%e6%95%b0%e6%8d%ae","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2013\/11\/18\/%e6%8c%89%e6%9c%88%e7%bb%9f%e8%ae%a1%e6%95%b0%e6%8d%ae\/","title":{"rendered":"\u6309\u6708\u7edf\u8ba1\u6570\u636e"},"content":{"rendered":"<div>\n<pre class=\"brush:sql;first-line:1;pad-line-numbers:true;highlight:null;collapse:false;\">\r\n--\u8bbe\u7f6e\u5468\u4e00\u4e3a\u7b2c\u4e00\u5929,\u9ed8\u8ba4\u4e3a\u5468\u65e5\u4e3a\u7b2c\u4e00\u5929\r\nSET DATEFIRST 1\r\n\r\n--\u83b7\u53d6\u672c\u5468\u662f\u4eca\u5e74\u7684\u7b2c\u51e0\u4e2a\u661f\u671f\r\nSELECT DATEPART(week,GETDATE())\r\n\r\n--\u4eca\u5929\u662f\u7b2c\u51e0\u4e2a\u5b63\u5ea6\r\nSELECT DATEPART(quarter,GETDATE())\r\n\r\n--\u6309\u5468\u7edf\u8ba1\u6570\u636e\uff0c\u8981\u6c42\u663e\u793a\u6bcf\u5468\u5f00\u5934\u4e0e\u7ed3\u5c3e\u65f6\u95f4\r\ndeclare @num int,@year varchar(4),@date datetime\r\nselect @num=45\r\nselect @year=&#39;2008-01-01&#39;\r\nselect @date=dateadd(wk,@num-1,@year)\r\nselect dateadd(dd,1-datepart(dw,@date),@date),dateadd(dd,7-datepart(dw,@date),@date)\r\n\r\n<\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;\u8bbe\u7f6e\u5468\u4e00\u4e3a\u7b2c\u4e00\u5929,\u9ed8\u8ba4\u4e3a\u5468\u65e5\u4e3a\u7b2c\u4e00\u5929 SET DATEFIRST 1 &#8211;\u83b7\u53d6\u672c\u5468\u662f\u4eca\u5e74\u7684\u7b2c\u51e0\u4e2a\u661f\u671f SE [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-2922","post","type-post","status-publish","format-standard","hentry","category-sql"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2922","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=2922"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2922\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2922"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2922"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}