Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the breadcrumb-navxt domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/devtools/public_html/blog/wp-includes/functions.php on line 6131
{"id":518,"date":"2011-09-20T21:14:00","date_gmt":"2011-09-21T00:14:00","guid":{"rendered":"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/"},"modified":"2021-07-25T18:53:06","modified_gmt":"2021-07-25T21:53:06","slug":"funcao-para-verificar-dia-util-no-mysql","status":"publish","type":"post","link":"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/","title":{"rendered":"Fun\u00e7\u00e3o para verificar dia \u00fatil no MySQL"},"content":{"rendered":"\n

Percebi que o post Fun\u00e7\u00e3o para verificar dia \u00fatil no PostgreSQL<\/a> foi um sucesso, e houveram v\u00e1rias pessoas que buscaram pela mesma fun\u00e7\u00e3o mas no MySQL, ent\u00e3o vamos a ela.<\/p>\n\n\n\n

Tamb\u00e9m ressalto que, para fazer uma fun\u00e7\u00e3o bem completa, ter\u00edamos que ter uma tabela que registraria os feriados federais, estaduais e municipais, mas o intuito aqui \u00e9 somente para saber se a data cai ou n\u00e3o em um s\u00e1bado ou domingo.<\/p>\n\n\n\n

Vamos \u00e0 fun\u00e7\u00e3o:<\/p>\n\n\n\n

1:  Delimiter $  \n2:  Create Function `fun_eh_dia_util`(p_data DateTime) Returns Int(11)  \n3:  Begin  \n4:     Declare l_ret Integer Default 1;   \n5:     If (Weekday(p_data) In (5,6)) Then  \n6:     Set l_ret = -1;   \n7:     End If;   \n8:  Return l_ret;   \n9:  End$   \n10:  Delimiter ;   \n<\/code><\/pre>\n\n\n\n
Pronto, agora mais um vez, vamos a explica\u00e7\u00e3o do c\u00f3digo. Recebemos\u00a0atrav\u00e9s do par\u00e2metro a data a ser verificada, declaramos uma vari\u00e1vel que ser\u00e1 nosso retorno de tipo integer, (Por padr\u00e3o, j\u00e1 seto como um dia \u00fatil o retorno).<\/p>\n\n\n\n
Ai vem a verifica\u00e7\u00e3o, se o dia da semana for 5 (Cinco) ou 6 (Seis) ent\u00e3o seto a vari\u00e1vel de retorno como -1 (Menos um), ou seja, falso, e pronto, esta feito nossa fun\u00e7\u00e3o.<\/p>\n\n\n\n
No MySQL, a semana inicia-se na Segunda, vejamos<\/p>\n\n\n\n
Segunda = 0
Ter\u00e7a = 1
Quarta = 2
Quinta = 3
Sexta = 4
S\u00e1bado = 5
Domingo = 6.<\/p>\n\n\n\n
Agora, \u00e9 s\u00f3 coloca-la em funcionamento.<\/p>\n\n\n\n
Um grande abra\u00e7o, e at\u00e9 a pr\u00f3xima.<\/p>\n","protected":false},"excerpt":{"rendered":"
Percebi que o post Fun\u00e7\u00e3o para verificar dia \u00fatil no PostgreSQL foi um sucesso, e houveram v\u00e1rias pessoas que buscaram pela mesma fun\u00e7\u00e3o mas no MySQL, ent\u00e3o vamos a ela. Tamb\u00e9m ressalto que, para fazer uma fun\u00e7\u00e3o bem completa, ter\u00edamos que ter uma tabela que registraria os feriados federais, estaduais e municipais, mas o intuito aqui … Ler mais<\/a><\/p>\n","protected":false},"author":1,"featured_media":849,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[272,49],"tags":[],"class_list":["post-518","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-banco-de-dados","category-mysql"],"yoast_head":"\nFun\u00e7\u00e3o para verificar dia \u00fatil no MySQL<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o para verificar dia \u00fatil no MySQL\" \/>\n<meta property=\"og:description\" content=\"Percebi que o post Fun\u00e7\u00e3o para verificar dia \u00fatil no PostgreSQL foi um sucesso, e houveram v\u00e1rias pessoas que buscaram pela mesma fun\u00e7\u00e3o mas no MySQL, ent\u00e3o vamos a ela. Tamb\u00e9m ressalto que, para fazer uma fun\u00e7\u00e3o bem completa, ter\u00edamos que ter uma tabela que registraria os feriados federais, estaduais e municipais, mas o intuito aqui ... Ler mais\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Devtools\" \/>\n<meta property=\"article:published_time\" content=\"2011-09-21T00:14:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-25T21:53:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png\" \/>\n\t<meta property=\"og:image:width\" content=\"3000\" \/>\n\t<meta property=\"og:image:height\" content=\"2000\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Fabiano Abreu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fabiano Abreu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/\"},\"author\":{\"name\":\"Fabiano Abreu\",\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\"},\"headline\":\"Fun\u00e7\u00e3o para verificar dia \u00fatil no MySQL\",\"datePublished\":\"2011-09-21T00:14:00+00:00\",\"dateModified\":\"2021-07-25T21:53:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/\"},\"wordCount\":203,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\"},\"image\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png\",\"articleSection\":[\"Banco de Dados\",\"MySQL\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/\",\"url\":\"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/\",\"name\":\"Fun\u00e7\u00e3o para verificar dia \u00fatil no MySQL\",\"isPartOf\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png\",\"datePublished\":\"2011-09-21T00:14:00+00:00\",\"dateModified\":\"2021-07-25T21:53:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/#primaryimage\",\"url\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png\",\"contentUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png\",\"width\":3000,\"height\":2000,\"caption\":\"MySQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/devtools.com.br\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fun\u00e7\u00e3o para verificar dia \u00fatil no MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/devtools.com.br\/blog\/#website\",\"url\":\"https:\/\/devtools.com.br\/blog\/\",\"name\":\"Devtools\",\"description\":\"Sua caixa de ferramentas online\",\"publisher\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/devtools.com.br\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\",\"name\":\"Fabiano Abreu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png\",\"contentUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png\",\"width\":184,\"height\":184,\"caption\":\"Fabiano Abreu\"},\"logo\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/devtools.com.br\/blog\"],\"url\":\"https:\/\/devtools.com.br\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o para verificar dia \u00fatil no MySQL","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/","og_locale":"pt_BR","og_type":"article","og_title":"Fun\u00e7\u00e3o para verificar dia \u00fatil no MySQL","og_description":"Percebi que o post Fun\u00e7\u00e3o para verificar dia \u00fatil no PostgreSQL foi um sucesso, e houveram v\u00e1rias pessoas que buscaram pela mesma fun\u00e7\u00e3o mas no MySQL, ent\u00e3o vamos a ela. Tamb\u00e9m ressalto que, para fazer uma fun\u00e7\u00e3o bem completa, ter\u00edamos que ter uma tabela que registraria os feriados federais, estaduais e municipais, mas o intuito aqui ... Ler mais","og_url":"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/","og_site_name":"Devtools","article_published_time":"2011-09-21T00:14:00+00:00","article_modified_time":"2021-07-25T21:53:06+00:00","og_image":[{"width":3000,"height":2000,"url":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png","type":"image\/png"}],"author":"Fabiano Abreu","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Fabiano Abreu","Est. tempo de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/#article","isPartOf":{"@id":"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/"},"author":{"name":"Fabiano Abreu","@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed"},"headline":"Fun\u00e7\u00e3o para verificar dia \u00fatil no MySQL","datePublished":"2011-09-21T00:14:00+00:00","dateModified":"2021-07-25T21:53:06+00:00","mainEntityOfPage":{"@id":"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/"},"wordCount":203,"commentCount":0,"publisher":{"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed"},"image":{"@id":"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png","articleSection":["Banco de Dados","MySQL"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/","url":"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/","name":"Fun\u00e7\u00e3o para verificar dia \u00fatil no MySQL","isPartOf":{"@id":"https:\/\/devtools.com.br\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/#primaryimage"},"image":{"@id":"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png","datePublished":"2011-09-21T00:14:00+00:00","dateModified":"2021-07-25T21:53:06+00:00","breadcrumb":{"@id":"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/#primaryimage","url":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png","contentUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png","width":3000,"height":2000,"caption":"MySQL"},{"@type":"BreadcrumbList","@id":"https:\/\/devtools.com.br\/blog\/funcao-para-verificar-dia-util-no-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/devtools.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"Fun\u00e7\u00e3o para verificar dia \u00fatil no MySQL"}]},{"@type":"WebSite","@id":"https:\/\/devtools.com.br\/blog\/#website","url":"https:\/\/devtools.com.br\/blog\/","name":"Devtools","description":"Sua caixa de ferramentas online","publisher":{"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devtools.com.br\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":["Person","Organization"],"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed","name":"Fabiano Abreu","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/","url":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png","contentUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png","width":184,"height":184,"caption":"Fabiano Abreu"},"logo":{"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/devtools.com.br\/blog"],"url":"https:\/\/devtools.com.br\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts\/518","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/comments?post=518"}],"version-history":[{"count":2,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts\/518\/revisions"}],"predecessor-version":[{"id":1180,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts\/518\/revisions\/1180"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/media\/849"}],"wp:attachment":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/media?parent=518"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/categories?post=518"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/tags?post=518"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}