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":443,"date":"2013-12-11T18:03:00","date_gmt":"2013-12-11T21:03:00","guid":{"rendered":"https:\/\/devtools.com.br\/blog\/como-somar-datas-no-mysql\/"},"modified":"2023-08-10T16:40:27","modified_gmt":"2023-08-10T19:40:27","slug":"como-somar-datas-no-mysql","status":"publish","type":"post","link":"https:\/\/devtools.com.br\/blog\/como-somar-datas-no-mysql\/","title":{"rendered":"Como Somar Datas no MySQL"},"content":{"rendered":"\n

Abordaremos neste artigo as seguintes fun\u00e7\u00f5es nativas do MySQL<\/p>\n\n\n\n

date_add<\/b>
Recomendada para adicionar valores a uma data.<\/i><\/li>\n\n\n\n

date_sub<\/b>
Recomendada para reduzir valores a uma data.<\/i><\/li>\n<\/ul>\n\n\n\n
Sintaxe<\/span><\/p>\n\n\n\n
DATE_ADD(date<\/b>,INTERVAL expr unit<\/b>)<\/i>
DATE_SUB(date<\/b>,INTERVAL expr unit<\/b>)<\/i><\/p>\n\n\n\n
Defini\u00e7\u00f5es da Sintaxe<\/span><\/p>\n\n\n\n
\n
date (Data)<\/i><\/b>
Argumento base para o calculo, sendo poss\u00edvel informar datas simples ou completas. (Com ou sem horas, minutos e segundos)\u00b9<\/b>.<\/li>\n\n\n\n
interval (Intervalo)<\/i>
Palavra chave da sintaxe.<\/li>\n\n\n\n
expr (Express\u00e3o)<\/i><\/b>
Argumento da express\u00e3o que ser\u00e1 utilizada como intervalo da fun\u00e7\u00e3o, possui tipo de dados do tipo string, que pode come\u00e7ar com menos (-) nos casos de subtra\u00e7\u00e3o\u00b2<\/b>.<\/li>\n\n\n\n
unit (Unidade)<\/b>
Argumento chave que indica qual unidade de “medida” ser\u00e1 usado, anos, dias, meses, horas…<\/li>\n<\/ol>\n\n\n\n
Exemplos (Adi\u00e7\u00e3o)<\/span><\/p>\n\n\n\n
1. Adicionando um ano sob a data atual.<\/p>\n\n\n\n
<\/code>select<\/span><\/code> <\/code>date_add<\/span><\/code>(<\/code>now<\/span><\/code>(), <\/code>interval <\/span><\/code>1 <\/code>year<\/span><\/code>) \n<\/code><\/pre>\n\n\n\n2. Adicionando um m\u00eas sob a data atual<\/p>\n\n\n\n <\/code>select <\/span><\/code>date_add<\/span><\/code>(<\/code>now<\/span><\/code>(), <\/code>interval <\/span><\/code>1 <\/code>month<\/span><\/code>) \n<\/code><\/pre>\n\n\n\n3. Adicionando um dia sob a data atual<\/p>\n\n\n\n <\/code>select <\/span><\/code>date_add<\/span><\/code>(<\/code>now<\/span><\/code>(), <\/code>interval <\/span><\/code>1 <\/code>day<\/span><\/code>) \n<\/code><\/pre>\n\n\n\n4. Adicionando uma hora sob a data atual<\/p>\n\n\n\n <\/code>select <\/span><\/code>date_add<\/span><\/code>(<\/code>now<\/span><\/code>(), <\/code>interval <\/span><\/code>1 <\/code>hour<\/span><\/code>) \n<\/code><\/pre>\n\n\n\n<\/p>\n\n\n\n \n