{"id":562,"date":"2021-09-27T16:09:22","date_gmt":"2021-09-27T20:09:22","guid":{"rendered":"https:\/\/tecgesco.com\/blog\/?p=562"},"modified":"2026-08-03T10:28:15","modified_gmt":"2026-08-03T14:28:15","slug":"firebird-primeiro-e-ultimo-dia-do-mes-atual","status":"publish","type":"post","link":"https:\/\/tecgesco.com\/blog\/firebird-primeiro-e-ultimo-dia-do-mes-atual\/","title":{"rendered":"Firebird &#8211; Primeiro e Ultimo dia do m\u00eas atual"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Em determinados momentos precisamos saber o primeiro e ultima dia do m\u00eas atual. O primeiro dia \u00e9 f\u00e1cil, sempre \u00e9 dia 01, o problema est\u00e1 no ultimo dia que pode variar de acordo com o m\u00eas.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span>\n    <span class=\"hljs-keyword\">DATEADD<\/span>(<span class=\"hljs-number\">1<\/span> - <span class=\"hljs-keyword\">EXTRACT<\/span>(<span class=\"hljs-keyword\">DAY<\/span> <span class=\"hljs-keyword\">FROM<\/span> <span class=\"hljs-keyword\">CURRENT_DATE<\/span>) <span class=\"hljs-keyword\">DAY<\/span> <span class=\"hljs-keyword\">TO<\/span> <span class=\"hljs-keyword\">CURRENT_DATE<\/span>) <span class=\"hljs-keyword\">AS<\/span> PRIMEIRO_DIA,\n    <span class=\"hljs-keyword\">DATEADD<\/span>(<span class=\"hljs-number\">-1<\/span> <span class=\"hljs-keyword\">DAY<\/span> <span class=\"hljs-keyword\">TO<\/span>\n        <span class=\"hljs-keyword\">DATEADD<\/span>(<span class=\"hljs-number\">1<\/span> <span class=\"hljs-keyword\">MONTH<\/span> <span class=\"hljs-keyword\">TO<\/span>\n            <span class=\"hljs-keyword\">DATEADD<\/span>(<span class=\"hljs-number\">1<\/span> - <span class=\"hljs-keyword\">EXTRACT<\/span>(<span class=\"hljs-keyword\">DAY<\/span> <span class=\"hljs-keyword\">FROM<\/span> <span class=\"hljs-keyword\">CURRENT_DATE<\/span>) <span class=\"hljs-keyword\">DAY<\/span> <span class=\"hljs-keyword\">TO<\/span> <span class=\"hljs-keyword\">CURRENT_DATE<\/span>)\n        )\n    ) <span class=\"hljs-keyword\">AS<\/span> ULTIMO_DIA\n<span class=\"hljs-keyword\">FROM<\/span> RDB$<span class=\"hljs-keyword\">DATABASE<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Em determinados momentos precisamos saber o primeiro e ultima dia do m\u00eas atual. O primeiro dia \u00e9 f\u00e1cil, sempre \u00e9 dia 01, o problema est\u00e1 no ultimo dia que pode variar de acordo com o m\u00eas.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5],"tags":[96,99,117,116,114,113,112,115],"class_list":["post-562","post","type-post","status-publish","format-standard","hentry","category-tecnico","tag-data","tag-firebird","tag-funcao","tag-mes","tag-primeiro-dia","tag-select","tag-sql","tag-ultimo-dia"],"_links":{"self":[{"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/posts\/562","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/comments?post=562"}],"version-history":[{"count":8,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/posts\/562\/revisions"}],"predecessor-version":[{"id":1684,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/posts\/562\/revisions\/1684"}],"wp:attachment":[{"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/media?parent=562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/categories?post=562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/tags?post=562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}