{"id":124,"date":"2014-04-23T12:27:00","date_gmt":"2014-04-23T11:27:00","guid":{"rendered":"https:\/\/debuggersspace.com\/index.php\/2014\/04\/23\/how-to-find-last-day-of-any-month\/"},"modified":"2014-04-23T12:27:00","modified_gmt":"2014-04-23T11:27:00","slug":"how-to-find-last-day-of-any-month","status":"publish","type":"post","link":"https:\/\/debuggersspace.com\/index.php\/2014\/04\/23\/how-to-find-last-day-of-any-month\/","title":{"rendered":"How to find Last Day of Any Month?"},"content":{"rendered":"
\n
\n \t<\/i> Read Time:<\/span>16 Second <\/div>\n\n <\/div>
\n<\/p>\n
    \n
  • Last Day of Previous <\/b>Month<\/span>SELECT <\/span>DATEADD<\/span>(<\/span>s<\/span>,-<\/span>1<\/span>,<\/span>DATEADD<\/span>(<\/span>mm<\/span>, <\/span>DATEDIFF<\/span>(<\/span>m<\/span>,<\/span>0<\/span>,<\/span>GETDATE<\/span>()),<\/span>0<\/span>))<\/span><\/li>\n<\/ul>\n
      \n
    • Last Day of Current Month<\/b><\/span>SELECT <\/span>DATEADD<\/span>(<\/span>s<\/span>,-<\/span>1<\/span>,<\/span>DATEADD<\/span>(<\/span>mm<\/span>, <\/span>DATEDIFF<\/span>(<\/span>m<\/span>,<\/span>0<\/span>,<\/span>GETDATE<\/span>())+<\/span>1<\/span>,<\/span>0<\/span>))<\/span><\/span><\/li>\n<\/ul>\n
        \n
      • Last Day of Next Month<\/b><\/span>SELECT <\/span>DATEADD<\/span>(<\/span>s<\/span>,-<\/span>1<\/span>,<\/span>DATEADD<\/span>(<\/span>mm<\/span>, <\/span>DATEDIFF<\/span>(<\/span>m<\/span>,<\/span>0<\/span>,<\/span>GETDATE<\/span>())+<\/span>2<\/span>,<\/span>0<\/span>))<\/span><\/span><\/li>\n<\/ul>\n


        <\/span><\/span><\/div>\n","protected":false},"excerpt":{"rendered":"

        Last Day of Previous MonthSELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) Last Day of Current MonthSELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0)) Last Day of Next MonthSELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+2,0))<\/p>\n","protected":false},"author":43,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","footnotes":""},"categories":[27],"tags":[],"class_list":["post-124","post","type-post","status-publish","format-standard","hentry","category-sql"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Himanshu Namdeo","author_link":"https:\/\/debuggersspace.com\/author\/admin\/"},"uagb_comment_info":0,"uagb_excerpt":"Last Day of Previous MonthSELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) Last Day of Current MonthSELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0)) Last Day of Next MonthSELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+2,0))","_links":{"self":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts\/124"}],"collection":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/users\/43"}],"replies":[{"embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/comments?post=124"}],"version-history":[{"count":0,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts\/124\/revisions"}],"wp:attachment":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/media?parent=124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/categories?post=124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/tags?post=124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}