{"id":696,"date":"2019-10-31T14:49:25","date_gmt":"2019-10-31T06:49:25","guid":{"rendered":"http:\/\/suherman.asia\/w2\/?p=696"},"modified":"2019-10-31T15:02:47","modified_gmt":"2019-10-31T07:02:47","slug":"menampilkan-format-tahunbulan-di-mysql","status":"publish","type":"post","link":"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html","title":{"rendered":"Menampilkan Format TahunBulan di MySQL utk Bulan lalu"},"content":{"rendered":"\n<p>kadang kita diminta untuk membuat sebuah string atau integer yang memiliki makna angka Tahun bulan atau berformat YYYYMm yang dihasilkan dari query database MySQL yang merupakan bulan lalu dari skr<\/p>\n\n\n\n<p>berikut ini adalah Query untuk menghasilkan data tersebut<\/p>\n\n\n<p>Select DATE_FORMAT( DATE_ADD(LAST_DAY(CURDATE()), interval ((DAYOFMONTH(LAST_DAY(CURDATE())))*-1) DAY), &#8216;%Y%m&#8217; )<\/p>\n\n\n\n<p>Demikian selamat mencoba<\/p>\n","protected":false},"excerpt":{"rendered":"<p>kadang kita diminta untuk membuat sebuah string atau integer yang memiliki makna angka Tahun bulan atau berformat YYYYMm yang dihasilkan dari query database MySQL yang merupakan bulan lalu dari skr berikut ini adalah Query untuk menghasilkan data tersebut Demikian selamat mencoba<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html\">Continue reading<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":698,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,1],"tags":[137,138,17],"class_list":["post-696","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-community","category-uncategorized","tag-mysql","tag-tips","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Menampilkan Format TahunBulan di MySQL utk Bulan lalu - Suherman Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Menampilkan Format TahunBulan di MySQL utk Bulan lalu - Suherman Blog\" \/>\n<meta property=\"og:description\" content=\"kadang kita diminta untuk membuat sebuah string atau integer yang memiliki makna angka Tahun bulan atau berformat YYYYMm yang dihasilkan dari query database MySQL yang merupakan bulan lalu dari skr berikut ini adalah Query untuk menghasilkan data tersebut Demikian selamat mencoba Continue reading\" \/>\n<meta property=\"og:url\" content=\"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html\" \/>\n<meta property=\"og:site_name\" content=\"Suherman Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-31T06:49:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-10-31T07:02:47+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2019\/10\/MySQL-Query-Commands.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html#article\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html\"},\"author\":{\"name\":\"admin\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"headline\":\"Menampilkan Format TahunBulan di MySQL utk Bulan lalu\",\"datePublished\":\"2019-10-31T06:49:25+00:00\",\"dateModified\":\"2019-10-31T07:02:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html\"},\"wordCount\":67,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2019\/10\/MySQL-Query-Commands.jpg\",\"keywords\":[\"MySQL\",\"Tips\",\"Tutorial\"],\"articleSection\":[\"Community\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html\",\"url\":\"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html\",\"name\":\"Menampilkan Format TahunBulan di MySQL utk Bulan lalu - Suherman Blog\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html#primaryimage\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2019\/10\/MySQL-Query-Commands.jpg\",\"datePublished\":\"2019-10-31T06:49:25+00:00\",\"dateModified\":\"2019-10-31T07:02:47+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html#primaryimage\",\"url\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2019\/10\/MySQL-Query-Commands.jpg\",\"contentUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2019\/10\/MySQL-Query-Commands.jpg\",\"width\":900,\"height\":500},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/suherman.asia\/w2\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Menampilkan Format TahunBulan di MySQL utk Bulan lalu\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/suherman.asia\/w2\/#website\",\"url\":\"http:\/\/suherman.asia\/w2\/\",\"name\":\"Suherman Blog\",\"description\":\"Just Another Geek Site\",\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/suherman.asia\/w2\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"caption\":\"admin\"},\"logo\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/suherman.asia\",\"https:\/\/www.facebook.com\/emantin34\",\"https:\/\/x.com\/emantin34\"],\"url\":\"http:\/\/suherman.asia\/w2\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Menampilkan Format TahunBulan di MySQL utk Bulan lalu - Suherman Blog","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":"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html","og_locale":"en_US","og_type":"article","og_title":"Menampilkan Format TahunBulan di MySQL utk Bulan lalu - Suherman Blog","og_description":"kadang kita diminta untuk membuat sebuah string atau integer yang memiliki makna angka Tahun bulan atau berformat YYYYMm yang dihasilkan dari query database MySQL yang merupakan bulan lalu dari skr berikut ini adalah Query untuk menghasilkan data tersebut Demikian selamat mencoba Continue reading","og_url":"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html","og_site_name":"Suherman Blog","article_publisher":"https:\/\/www.facebook.com\/emantin34","article_author":"https:\/\/www.facebook.com\/emantin34","article_published_time":"2019-10-31T06:49:25+00:00","article_modified_time":"2019-10-31T07:02:47+00:00","og_image":[{"width":900,"height":500,"url":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2019\/10\/MySQL-Query-Commands.jpg","type":"image\/jpeg"}],"author":"admin","twitter_misc":{"Written by":"admin"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html#article","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html"},"author":{"name":"admin","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"headline":"Menampilkan Format TahunBulan di MySQL utk Bulan lalu","datePublished":"2019-10-31T06:49:25+00:00","dateModified":"2019-10-31T07:02:47+00:00","mainEntityOfPage":{"@id":"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html"},"wordCount":67,"commentCount":0,"publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"image":{"@id":"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html#primaryimage"},"thumbnailUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2019\/10\/MySQL-Query-Commands.jpg","keywords":["MySQL","Tips","Tutorial"],"articleSection":["Community"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html#respond"]}]},{"@type":"WebPage","@id":"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html","url":"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html","name":"Menampilkan Format TahunBulan di MySQL utk Bulan lalu - Suherman Blog","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/#website"},"primaryImageOfPage":{"@id":"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html#primaryimage"},"image":{"@id":"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html#primaryimage"},"thumbnailUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2019\/10\/MySQL-Query-Commands.jpg","datePublished":"2019-10-31T06:49:25+00:00","dateModified":"2019-10-31T07:02:47+00:00","breadcrumb":{"@id":"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html#primaryimage","url":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2019\/10\/MySQL-Query-Commands.jpg","contentUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2019\/10\/MySQL-Query-Commands.jpg","width":900,"height":500},{"@type":"BreadcrumbList","@id":"http:\/\/suherman.asia\/w2\/menampilkan-format-tahunbulan-di-mysql.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/suherman.asia\/w2"},{"@type":"ListItem","position":2,"name":"Menampilkan Format TahunBulan di MySQL utk Bulan lalu"}]},{"@type":"WebSite","@id":"http:\/\/suherman.asia\/w2\/#website","url":"http:\/\/suherman.asia\/w2\/","name":"Suherman Blog","description":"Just Another Geek Site","publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/suherman.asia\/w2\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","caption":"admin"},"logo":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/suherman.asia","https:\/\/www.facebook.com\/emantin34","https:\/\/x.com\/emantin34"],"url":"http:\/\/suherman.asia\/w2\/author\/admin"}]}},"_links":{"self":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/696","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/comments?post=696"}],"version-history":[{"count":2,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/696\/revisions"}],"predecessor-version":[{"id":699,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/696\/revisions\/699"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media\/698"}],"wp:attachment":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media?parent=696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/categories?post=696"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/tags?post=696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}