{"id":605,"date":"2020-10-02T14:07:51","date_gmt":"2020-10-02T17:07:51","guid":{"rendered":"https:\/\/www.gnial.com.br\/gnialhelp\/?p=605"},"modified":"2020-10-02T14:35:44","modified_gmt":"2020-10-02T17:35:44","slug":"sql-diff-date-days-of-month-or-month","status":"publish","type":"post","link":"http:\/\/www.gnial.com.br\/gnialhelp\/sql-diff-date-days-of-month-or-month\/","title":{"rendered":"SQL – Diff Date, days of month or month"},"content":{"rendered":"

How to get the number of days of difference between two dates<\/h3>\n

Days<\/h3>\n

\/\/most close date and any date<\/p>\n

SELECT DATEDIFF(NOW(),'2020-05-05')<\/pre>\n
Month<\/h3>\n
Month-diference between any given two dates<\/p>\n
SELECT TIMESTAMPDIFF(MONTH, '2012-05-05', '2012-06-04')\r\n-- Outputs: 0\r\nSELECT TIMESTAMPDIFF(MONTH, '2012-05-05', '2012-06-05')\r\n-- Outputs: 1\r\nSELECT TIMESTAMPDIFF(MONTH, '2012-05-05', '2012-06-15')\r\n-- Outputs: 1\r\nSELECT TIMESTAMPDIFF(MONTH, '2012-05-05', '2012-12-16')\r\n-- Outputs: 7<\/pre>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
How to get the number of days of difference between two dates Days \/\/most close date and any date SELECT DATEDIFF(NOW(),’2020-05-05′) Month Month-diference between any given two dates SELECT TIMESTAMPDIFF(MONTH, ‘2012-05-05’, ‘2012-06-04’) — Outputs: 0 SELECT TIMESTAMPDIFF(MONTH, ‘2012-05-05’, ‘2012-06-05’) — Outputs: 1 SELECT TIMESTAMPDIFF(MONTH, ‘2012-05-05’, ‘2012-06-15’) — Outputs: 1 SELECT TIMESTAMPDIFF(MONTH, ‘2012-05-05’, ‘2012-12-16’) — Outputs: […]<\/p>\n","protected":false},"author":1,"featured_media":565,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-605","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","has-thumbnail"],"_links":{"self":[{"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/posts\/605","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/comments?post=605"}],"version-history":[{"count":1,"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/posts\/605\/revisions"}],"predecessor-version":[{"id":606,"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/posts\/605\/revisions\/606"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/media\/565"}],"wp:attachment":[{"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/media?parent=605"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/categories?post=605"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gnial.com.br\/gnialhelp\/wp-json\/wp\/v2\/tags?post=605"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}