{"id":928,"date":"2013-10-08T12:39:59","date_gmt":"2013-10-08T04:39:59","guid":{"rendered":"http:\/\/blog.fhps.tp.edu.tw\/fhpsmis\/?p=928"},"modified":"2013-10-08T12:53:43","modified_gmt":"2013-10-08T04:53:43","slug":"sql-%e7%af%a9%e9%81%b8%e6%97%a5%e6%9c%9f%e8%aa%9e%e6%b3%95","status":"publish","type":"post","link":"http:\/\/blog.fhps.tp.edu.tw\/fhpsmis\/?p=928","title":{"rendered":"SQL \u7be9\u9078\u65e5\u671f\u8a9e\u6cd5"},"content":{"rendered":"

–\u4eca\u5929<\/p>\n

Select * From TableName<\/span><\/em> Where DateDiff(dd, DateTimCol<\/em><\/span>, GetDate()) = 0<\/p>\n

<\/p>\n

–\u6628\u5929<\/p>\n

Select * From TableName<\/span><\/em> Where DateDiff(dd,DateTimCol<\/em><\/span>, GetDate()) = 1<\/p>\n

–\u660e\u5929<\/p>\n

Select * From TableName<\/em><\/span> Where DateDiff(dd,GetDate(),DateTimCol<\/em><\/span>\u00a0) = 1<\/p>\n

–\u6700\u8fd1\u4e03\u5929<\/p>\n

Select * From TableName<\/span><\/em> Where DateDiff(dd, DateTimCol, GetDate()) <= 7<\/p>\n

–\u96a8\u5f8c\u4e03\u5929<\/p>\n

Select * From TableName<\/span><\/em> Where DateDiff(dd,,GetDate(),DateTimCol<\/span><\/em>\u00a0) <= 7<\/p>\n

–\u4e0a\u9031<\/p>\n

Select * From TableName<\/span><\/em> Where DateDiff(wk, DateTimCol<\/span><\/em>, GetDate()) = 1<\/p>\n

–\u672c\u9031<\/p>\n

Select * From TableName<\/span><\/em> Where DateDiff(wk, DateTimCol<\/em><\/span>, GetDate()) = 0<\/p>\n

–\u4e0b\u9031<\/p>\n

Select * From TableName<\/span><\/em> Where DateDiff(wk,GetDate(),DateTimCol,<\/em><\/span>) = 1<\/p>\n

–\u4e0a\u6708<\/p>\n

Select * From TableName<\/span><\/em> Where DateDiff(mm, DateTimCol<\/span><\/em>, GetDate()) = 1<\/p>\n

–\u672c\u6708<\/p>\n

Select * From TableName<\/span><\/em> Where DateDiff(mm, DateTimCol<\/span><\/em>, GetDate()) = 0<\/p>\n

–\u4e0b\u6708<\/p>\n

Select * From TableName<\/span><\/em> Where DateDiff(mm,\u00a0GetDate(),DateTimCol<\/span><\/em>\u00a0) = 1<\/p>\n","protected":false},"excerpt":{"rendered":"

–\u4eca\u5929 Select * From TableName Where DateDiff(dd, Da […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_links_to":"","_links_to_target":""},"categories":[19],"tags":[],"_links":{"self":[{"href":"http:\/\/blog.fhps.tp.edu.tw\/fhpsmis\/index.php?rest_route=\/wp\/v2\/posts\/928"}],"collection":[{"href":"http:\/\/blog.fhps.tp.edu.tw\/fhpsmis\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.fhps.tp.edu.tw\/fhpsmis\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.fhps.tp.edu.tw\/fhpsmis\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.fhps.tp.edu.tw\/fhpsmis\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=928"}],"version-history":[{"count":4,"href":"http:\/\/blog.fhps.tp.edu.tw\/fhpsmis\/index.php?rest_route=\/wp\/v2\/posts\/928\/revisions"}],"predecessor-version":[{"id":932,"href":"http:\/\/blog.fhps.tp.edu.tw\/fhpsmis\/index.php?rest_route=\/wp\/v2\/posts\/928\/revisions\/932"}],"wp:attachment":[{"href":"http:\/\/blog.fhps.tp.edu.tw\/fhpsmis\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=928"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.fhps.tp.edu.tw\/fhpsmis\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=928"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.fhps.tp.edu.tw\/fhpsmis\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}