{"id":649,"date":"2022-09-19T21:18:18","date_gmt":"2022-09-19T12:18:18","guid":{"rendered":"https:\/\/blog.mydepot.kr\/?p=649"},"modified":"2022-09-19T21:18:18","modified_gmt":"2022-09-19T12:18:18","slug":"mysql-datetime-%ec%bb%ac%eb%9f%bc%ec%9d%84-%ec%8b%9c%ea%b0%84%ec%9c%bc%eb%a1%9c-%eb%b9%84%ea%b5%90%ed%95%98%ea%b8%b0-%ec%8b%9c%ea%b0%84-%eb%b2%94%ec%9c%84%eb%a5%bc-%ec%a1%b0%ea%b1%b4%ec%9c%bc","status":"publish","type":"post","link":"https:\/\/blog.mydepot.kr\/?p=649","title":{"rendered":"[mysql] datetime \uceec\ub7fc\uc744 \uc2dc\uac04\uc73c\ub85c \ube44\uad50\ud558\uae30 + \uc2dc\uac04 \ubc94\uc704\ub97c \uc870\uac74\uc73c\ub85c"},"content":{"rendered":"<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n\/\/ 16\uc2dc~20\uc2dc\uac00 \uc544\ub2cc \uacbd\uc6b0 (0\uc2dc~15\uc2dc59\ubd8459\ucd08 + 20\uc2dc~24\uc2dc)\nSELECT * FROM \ud14c\uc774\ube14\uba85 WHERE TIME(datetime\uceec\ub7fc\uba85) NOT BETWEEN &#039;16:00:00&#039; AND &#039;20:00:00&#039;\n\n\/\/ 9\uc2dc~18\uc2dc\uc778 \uacbd\uc6b0\nSELECT * FROM \ud14c\uc774\ube14\uba85 WHERE TIME(datetime\uceec\ub7fc\uba85) BETWEEN &#039;09:00:00&#039; AND &#039;18:00:00&#039;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[9],"tags":[205,269,286,303,304],"class_list":["post-649","post","type-post","status-publish","format-standard","hentry","category-sql","tag-query","tag-time","tag-286","tag-between","tag-not"],"modified_by":"\ucc38\ube5b\ubc14\ub2e4","_links":{"self":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/649","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=649"}],"version-history":[{"count":1,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/649\/revisions"}],"predecessor-version":[{"id":650,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/649\/revisions\/650"}],"wp:attachment":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}