{"id":562,"date":"2021-09-27T16:09:22","date_gmt":"2021-09-27T20:09:22","guid":{"rendered":"https:\/\/tecgesco.com\/blog\/?p=562"},"modified":"2023-06-16T09:26:00","modified_gmt":"2023-06-16T13:26:00","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>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\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>SELECT DATEADD(1 &#8211; EXTRACT(DAY FROM CURRENT_DATE) DAY TO CURRENT_DATE ) primeiro_dia FROM RDB$DATABASE;<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"141\" height=\"47\" src=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/06\/image-17.png\" alt=\"\" class=\"wp-image-1122\"\/><\/figure>\n<\/blockquote>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>SELECT DATEADD(-EXTRACT(DAY FROM DATEADD(1 MONTH TO CURRENT_DATE )) DAY TO DATEADD(1 MONTH TO CURRENT_DATE)) ultimo_dia FROM RDB$DATABASE;<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"132\" height=\"47\" src=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/06\/image-18.png\" alt=\"\" class=\"wp-image-1123\"\/><\/figure>\n<\/blockquote>\n\n\n\n<p><\/p>\n\n\n\n<p>Referencias :<\/p>\n\n\n\n<p><a href=\"https:\/\/firebirdsql.org\/refdocs\/langrefupd21-intfunc-dateadd.html\">https:\/\/firebirdsql.org\/refdocs\/langrefupd21-intfunc-dateadd.html<\/a><\/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. Referencias : https:\/\/firebirdsql.org\/refdocs\/langrefupd21-intfunc-dateadd.html<\/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":2,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/posts\/562\/revisions"}],"predecessor-version":[{"id":1124,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/posts\/562\/revisions\/1124"}],"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}]}}