{"id":679,"date":"2017-09-28T20:39:25","date_gmt":"2017-09-28T20:39:25","guid":{"rendered":"http:\/\/jonescarvalho.com\/Blog\/?p=679"},"modified":"2020-05-13T20:47:43","modified_gmt":"2020-05-13T23:47:43","slug":"query-de-evento-transacao-entre-periodo-start-e-end-datas-sql","status":"publish","type":"post","link":"https:\/\/jonescarvalho.com\/Blog\/?p=679","title":{"rendered":"Query de evento transa\u00e7\u00e3o entre periodo start e end Datas SQL"},"content":{"rendered":"<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">DECLARE\n@dtt_start datetime,\n@dtt_end datetime,\n@dtt_transacao datetime\n\nset @dtt_start = '2017-09-29 16:00:00';\nset @dtt_end = '2017-09-30 17:00:00';\n\nset @dtt_transacao = '2017-09-30 15:00:00';\n\ncreate table #temp(\ndtt_start datetime,\ndtt_end datetime)\n\n--select @dtt_start,@dtt_end\ninsert into #temp(dtt_start,dtt_end)values(@dtt_start,@dtt_end)\n\nselect 'esta dentro do range'\nfrom #temp\nwhere dtt_start &lt;= @dtt_transacao and dtt_end &gt;= @dtt_transacao\n\ndrop table #temp<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>DECLARE @dtt_start datetime, @dtt_end datetime, @dtt_transacao datetime set @dtt_start = &#8216;2017-09-29 16:00:00&#8217;; set [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[30],"class_list":["post-679","post","type-post","status-publish","format-standard","hentry","category-dicas","tag-sql"],"_links":{"self":[{"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/posts\/679"}],"collection":[{"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=679"}],"version-history":[{"count":2,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/posts\/679\/revisions"}],"predecessor-version":[{"id":833,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/posts\/679\/revisions\/833"}],"wp:attachment":[{"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}