{"id":2775,"date":"2019-11-13T11:39:18","date_gmt":"2019-11-13T03:39:18","guid":{"rendered":"http:\/\/jason695.why3s.tw\/wordpress\/?p=2775"},"modified":"2019-11-13T11:39:18","modified_gmt":"2019-11-13T03:39:18","slug":"sql-server%e4%b8%addatetime%e4%b8%8edatetime2%e7%9a%84%e5%8c%ba%e5%88%ab","status":"publish","type":"post","link":"https:\/\/jason695.why3s.tw\/wordpress\/2019\/11\/13\/sql-server%e4%b8%addatetime%e4%b8%8edatetime2%e7%9a%84%e5%8c%ba%e5%88%ab\/","title":{"rendered":"SQL Server\u4e2dDateTime\u4e0eDateTime2\u7684\u533a\u522b"},"content":{"rendered":"\n<p>DateTime\u5b57\u6bb5\u7c7b\u578b\u5bf9\u5e94\u7684\u65f6\u95f4\u683c\u5f0f\u662f&nbsp;yyyy-MM-dd HH:mm:ss.fff&nbsp;\uff0c3\u4e2af\uff0c\u7cbe\u786e\u52301\u6beb\u79d2(ms)\uff0c\u793a\u4f8b&nbsp;2014-12-03 17:06:15.433&nbsp;\u3002<\/p>\n\n\n\n<p>DateTime2\u5b57\u6bb5\u7c7b\u578b\u5bf9\u5e94\u7684\u65f6\u95f4\u683c\u5f0f\u662f&nbsp;yyyy-MM-dd HH:mm:ss.fffffff&nbsp;\uff0c7\u4e2af\uff0c\u7cbe\u786e\u52300.1\u5fae\u79d2(\u03bcs)\uff0c\u793a\u4f8b&nbsp;2014-12-03 17:23:19.2880929&nbsp;\u3002<\/p>\n\n\n\n<p>\u5982\u679c\u7528SQL\u7684\u65e5\u671f\u51fd\u6570\u8fdb\u884c\u8d4b\u503c\uff0cDateTime\u5b57\u6bb5\u7c7b\u578b\u8981\u7528\u00a0GETDATE()\u00a0\uff0cDateTime2\u5b57\u6bb5\u7c7b\u578b\u8981\u7528\u00a0SYSDATETIME()\u00a0\u3002<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>DateTime\u5b57\u6bb5\u7c7b\u578b\u5bf9\u5e94\u7684\u65f6\u95f4\u683c\u5f0f\u662f&nbsp;yyyy-MM-dd HH:mm:ss.fff&nbsp; &hellip; <a href=\"https:\/\/jason695.why3s.tw\/wordpress\/2019\/11\/13\/sql-server%e4%b8%addatetime%e4%b8%8edatetime2%e7%9a%84%e5%8c%ba%e5%88%ab\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587 <span class=\"screen-reader-text\">SQL Server\u4e2dDateTime\u4e0eDateTime2\u7684\u533a\u522b<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[47],"tags":[],"class_list":["post-2775","post","type-post","status-publish","format-standard","hentry","category-sql-server","no-featured-image"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/2775","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/comments?post=2775"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/2775\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=2775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=2775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=2775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}