{"id":31263,"date":"2023-01-20T09:52:47","date_gmt":"2023-01-20T04:22:47","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/"},"modified":"2023-01-20T09:52:47","modified_gmt":"2023-01-20T04:22:47","slug":"solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/","title":{"rendered":"[Solved] adddate(curdate(), -(day(curdate())-1)) and concat(last_day(curdate()),&#8217; 23:59:59&#8242;) [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-18255206\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"18255206\" data-parentid=\"18255017\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p><code>DAY(CURDATE())-1<\/code> is the current day of the month, less 1. For today (Aug 15, 2013), the value would be 14. Subtract 14 days from August 15 and you have August 1. In other words, <code>ADDDATE(CURDATE(), -(DAY(CURDATE())-1))<\/code> gives you the first day of the month.<\/p>\n<p><code>LAST_DAY(CURDATE())<\/code> gives you the last day of the month. If you call it today it will return August 31, 2013. Append the <code>23:59:59<\/code> and you have the last second of the last day of the month.<\/p>\n<p>In other words, if called on August 15, 2013, the values come out as <code>2013-08-01<\/code> and <code>2013-08-31 23:59:59<\/code>. If this range is applied against a <code>DATETIME<\/code> value, it means &#8220;anything in the month of August 2013&#8221;.<\/p>\n<p>This is actually a pretty good way to check for date\/time values within a month because it avoids using a function on the MySQL column that holds the date\/time. If the column has an index, the index will (probably) be used for optimization. One approach I often see is this:<\/p>\n<pre><code>WHERE DATE_FORMAT(myDateTime, '%Y%m') = DATE_FORMAT(CURDATE(), '%Y%m')\n<\/code><\/pre>\n<p>This reads a little better, but it kills optimization. I&#8217;d stick with the expression you already have.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">2<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved adddate(curdate(), -(day(curdate())-1)) and concat(last_day(curdate()),&#8217; 23:59:59&#8242;) [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] DAY(CURDATE())-1 is the current day of the month, less 1. For today (Aug 15, 2013), the value would be 14. Subtract 14 days from August 15 and you have August 1. In other words, ADDDATE(CURDATE(), -(DAY(CURDATE())-1)) gives you the first day of the month. LAST_DAY(CURDATE()) gives you the last day of the month. If &#8230; <a title=\"[Solved] adddate(curdate(), -(day(curdate())-1)) and concat(last_day(curdate()),&#8217; 23:59:59&#8242;) [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/\" aria-label=\"More on [Solved] adddate(curdate(), -(day(curdate())-1)) and concat(last_day(curdate()),&#8217; 23:59:59&#8242;) [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[340,339],"class_list":["post-31263","post","type-post","status-publish","format-standard","hentry","category-solved","tag-mysql","tag-php"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] adddate(curdate(), -(day(curdate())-1)) and concat(last_day(curdate()),&#039; 23:59:59&#039;) [closed] - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] adddate(curdate(), -(day(curdate())-1)) and concat(last_day(curdate()),&#039; 23:59:59&#039;) [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] DAY(CURDATE())-1 is the current day of the month, less 1. For today (Aug 15, 2013), the value would be 14. Subtract 14 days from August 15 and you have August 1. In other words, ADDDATE(CURDATE(), -(DAY(CURDATE())-1)) gives you the first day of the month. LAST_DAY(CURDATE()) gives you the last day of the month. If ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-20T04:22:47+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] adddate(curdate(), -(day(curdate())-1)) and concat(last_day(curdate()),&#8217; 23:59:59&#8242;) [closed]\",\"datePublished\":\"2023-01-20T04:22:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/\"},\"wordCount\":193,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"mysql\",\"php\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/\",\"name\":\"[Solved] adddate(curdate(), -(day(curdate())-1)) and concat(last_day(curdate()),' 23:59:59') [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2023-01-20T04:22:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] adddate(curdate(), -(day(curdate())-1)) and concat(last_day(curdate()),&#8217; 23:59:59&#8242;) [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] adddate(curdate(), -(day(curdate())-1)) and concat(last_day(curdate()),' 23:59:59') [closed] - JassWeb","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:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] adddate(curdate(), -(day(curdate())-1)) and concat(last_day(curdate()),' 23:59:59') [closed] - JassWeb","og_description":"[ad_1] DAY(CURDATE())-1 is the current day of the month, less 1. For today (Aug 15, 2013), the value would be 14. Subtract 14 days from August 15 and you have August 1. In other words, ADDDATE(CURDATE(), -(DAY(CURDATE())-1)) gives you the first day of the month. LAST_DAY(CURDATE()) gives you the last day of the month. If ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/","og_site_name":"JassWeb","article_published_time":"2023-01-20T04:22:47+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] adddate(curdate(), -(day(curdate())-1)) and concat(last_day(curdate()),&#8217; 23:59:59&#8242;) [closed]","datePublished":"2023-01-20T04:22:47+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/"},"wordCount":193,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["mysql","php"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/","name":"[Solved] adddate(curdate(), -(day(curdate())-1)) and concat(last_day(curdate()),' 23:59:59') [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2023-01-20T04:22:47+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-adddatecurdate-daycurdate-1-and-concatlast_daycurdate-235959-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] adddate(curdate(), -(day(curdate())-1)) and concat(last_day(curdate()),&#8217; 23:59:59&#8242;) [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/31263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=31263"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/31263\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=31263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=31263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=31263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}