{"id":339,"date":"2009-05-19T09:39:04","date_gmt":"2009-05-19T03:39:04","guid":{"rendered":"http:\/\/techsatwork.com\/blog\/?p=339"},"modified":"2016-01-07T11:31:12","modified_gmt":"2016-01-07T05:31:12","slug":"first-and-last-day-of-the-month","status":"publish","type":"post","link":"https:\/\/techsatwork.com\/?p=339","title":{"rendered":"first and last day of the month"},"content":{"rendered":"<p>Here is a quick way to find the first and last day of the month :<\/p>\n<p><span style=\"color: #0000ff;\">with temp1 (first_day_of_month,last_day_of_month)<br \/>\nas<br \/>\n(values ((current date &#8211; day(current date + 1 month) days) + 1 DAY,<br \/>\n\u00c2\u00a0(current date + 1 month) &#8211; day(current date +1 month) days)<br \/>\n)<br \/>\nselect * from temp1;<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here is a quick way to find the first and last day of the month : with temp1 (first_day_of_month,last_day_of_month) as (values ((current date &#8211; day(current date + 1 month) days) + 1 DAY, \u00c2\u00a0(current date + 1 month) &#8211; day(current date +1 month) days) ) select * from temp1;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[3],"tags":[210,943,8,209,211],"class_list":["post-339","post","type-post","status-publish","format-standard","hentry","category-db2","tag-current-date","tag-db2","tag-sql","tag-values","tag-with"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/339","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=339"}],"version-history":[{"count":2,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/339\/revisions"}],"predecessor-version":[{"id":341,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/339\/revisions\/341"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=339"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=339"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}