{"id":1106,"date":"2009-04-22T19:50:34","date_gmt":"2009-04-22T10:50:34","guid":{"rendered":"http:\/\/gigasmegas.com\/?p=1106"},"modified":"2009-04-22T20:01:36","modified_gmt":"2009-04-22T11:01:36","slug":"sql-server-2008%e3%81%a7datetime%e5%9e%8b%e3%81%ae%e9%a0%85%e7%9b%ae%e3%81%8b%e3%82%89where%e5%8f%a5%e3%81%a7%e8%a9%b2%e5%bd%93%e6%97%a5%e4%bb%98%e3%81%ae%e7%af%84%e5%9b%b2%e3%83%87%e3%83%bc%e3%82%bf","status":"publish","type":"post","link":"http:\/\/gigasmegas.com\/?p=1106","title":{"rendered":"SQL Server 2008\u3067datetime\u578b\u306e\u9805\u76ee\u304b\u3089Where\u53e5\u3067\u8a72\u5f53\u65e5\u4ed8\u306e\u7bc4\u56f2\u30c7\u30fc\u30bf\u62bd\u51fa"},"content":{"rendered":"<p><a onclick=\"javascript:pageTracker._trackPageview('\/outgoing\/rokuz.com\/?p=1106');\"  href=\"http:\/\/rokuz.com\/?p=1106\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/rokuz.com\/wp-content\/uploads\/2009\/04\/snag-0143-400x247.png\" alt=\"datetime\u578b\u306e\u9805\u76ee\u304b\u3089Where\u53e5\u3067\u8a72\u5f53\u65e5\u4ed8\u306e\u307f\u62bd\u51fa\" title=\"datetime\u578b\u306e\u9805\u76ee\u304b\u3089Where\u53e5\u3067\u8a72\u5f53\u65e5\u4ed8\u306e\u307f\u62bd\u51fa\" width=\"400\" height=\"247\" class=\"alignnone size-medium wp-image-1107\" srcset=\"http:\/\/gigasmegas.com\/wp-content\/uploads\/2009\/04\/snag-0143-400x247.png 400w, http:\/\/gigasmegas.com\/wp-content\/uploads\/2009\/04\/snag-0143.png 495w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/a><\/p>\n<address>photo by <a onclick=\"javascript:pageTracker._trackPageview('\/outgoing\/www.flickr.com\/photos\/sbh\/');\"  href=\"http:\/\/www.flickr.com\/photos\/sbh\/\">Steve-h<\/a><\/address>\n<p>SQL Server 2008\u304b\u3089\u3001Date\u578b\u3001Time\u578b\u304c\u8ffd\u52a0\u3068\u306a\u308a\u307e\u3057\u305f\u306d\u3002<\/p>\n<p>SQL Server 2005\u307e\u3067\u306f\u3001Datetime\u578b\u3057\u304b\u306a\u304f\u300c\u65e5\u4ed8\u306e\u307f\u4fdd\u6301\u3057\u305f\u3044\u306e\u306b\u2026\u300d\u3068\u304b\u3001\u300c\u6642\u523b\u306e\u307f\u4fdd\u6301\u3057\u305f\u3044\u2026\u300d\u3068\u3044\u3046\u5834\u5408\u3082\u3001datetime\u578b\u3067\u4ee3\u7528\u3057\u3066\u3044\u307e\u3057\u305f\u3002<br \/>\n\u3067\u3059\u304c\u3001\u65e5\u6642\u3092\u307e\u3068\u3081\u3066\u4fdd\u6301\u3057\u305f\u3044\u5834\u5408\u306f\u3001datetime\u578b\u3092\u5229\u7528\u3057\u307e\u3059\u3002<\/p>\n<p>\u305f\u3068\u3048\u3070\u3001 &#8216;2009\/01\/01&#8217;\u306e\u5024\u304c\u5165\u3063\u3066\u3044\u308b\u8a72\u5f53\u9805\u76ee\u3092\u62bd\u51fa\u3057\u305f\u3044\u3068\u304d\u3001\u4e0b\u8a18\u306e\u3088\u3046\u306b\u554f\u3044\u5408\u308f\u305b\u3066\u3082\u62bd\u51fa\u3067\u304d\u307e\u305b\u3093\u3002<br \/>\n\u6bd4\u8f03\u5bfe\u8c61\u304c\u3001datetime\u578b\u306a\u306e\u3067\u65e5\u4ed8\u3067\u306f\u306a\u3044\u304b\u3089\u3067\u3059\u3002<\/p>\n<p><!--more--><\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">\r\nSELECT * FROM hoge WHERE hoge_datetime = '2009\/01\/01'\r\n<\/pre>\n<p>\u3053\u3093\u306a\u3068\u304d\u306b\u3001convert\u95a2\u6570\u3092\u7528\u3044\u3066\u3001\u554f\u3044\u5408\u308f\u305b\u5148\u306e\u9805\u76ee\u3092\u65e5\u4ed8\u6bd4\u8f03\u304c\u3067\u304d\u308b\u3088\u3046\u30ad\u30e3\u30b9\u30c8\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">\r\nSELECT * FROM busy WHERE Convert(NVARCHAR, hoge_datetime, 111) = '2009\/01\/01'\r\n<\/pre>\n<p>Convert\u95a2\u6570\u3067\u3001\u4e0a\u306e\u4f8b\u3067\u306f\u3001 hoge_datetime\u9805\u76ee\u3092\u6307\u5b9a\u30b9\u30bf\u30a4\u30eb\uff08111(4\u6841\u306e\u5e74\u3001\u65e5\u672c\u3001yy\/mm\/dd)\uff09\u306b\u30ad\u30e3\u30b9\u30c8\u3057\u3066\u6bd4\u8f03\u3055\u308c\u307e\u3059\u3002<br \/>\n<a href=\"http:\/\/msdn.microsoft.com\/ja-jp\/library\/ms187928.aspx\"><br \/>\nMSDN SQL Server 2008 \u30aa\u30f3\u30e9\u30a4\u30f3 \u30d6\u30c3\u30af CAST \u304a\u3088\u3073 CONVERT (Transact-SQL)<\/a><\/p>\n<p>SQL Server Compact 3.5\u3067\u3082Convert\u95a2\u6570\u306f\u4f7f\u7528\u53ef\u80fd\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>photo by Steve-h SQL Server 2008\u304b\u3089\u3001Date\u578b\u3001Time\u578b\u304c\u8ffd\u52a0\u3068\u306a\u308a\u307e\u3057\u305f\u306d\u3002 SQL Server 2005\u307e\u3067\u306f\u3001Datetime\u578b\u3057\u304b\u306a\u304f\u300c\u65e5\u4ed8\u306e\u307f\u4fdd\u6301\u3057\u305f\u3044\u306e\u306b\u2026\u300d\u3068\u304b\u3001\u300c\u6642\u523b [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31,32],"tags":[328,272,252,251,353,352,250,157],"class_list":["post-1106","post","type-post","status-publish","format-standard","hentry","category-sqlserver","category-database","tag-328","tag-272","tag-252","tag-compact","tag-convert","tag-datetime","tag-sql","tag-157"],"_links":{"self":[{"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/posts\/1106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1106"}],"version-history":[{"count":5,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/posts\/1106\/revisions"}],"predecessor-version":[{"id":1114,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/posts\/1106\/revisions\/1114"}],"wp:attachment":[{"href":"http:\/\/gigasmegas.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1106"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}