{"id":8776,"date":"2013-08-07T18:16:21","date_gmt":"2013-08-07T23:16:21","guid":{"rendered":"http:\/\/www.jbaker.info\/?p=7932"},"modified":"2015-01-01T16:55:05","modified_gmt":"2015-01-01T22:55:05","slug":"how-to-clear-the-scheduled-date-for-all-wordpress-draft-posts","status":"publish","type":"post","link":"https:\/\/www.jbaker.info\/demo05\/how-to-clear-the-scheduled-date-for-all-wordpress-draft-posts\/","title":{"rendered":"How to Clear the Scheduled Date for all WordPress Draft Posts"},"content":{"rendered":"<p>Use this SQL Query<\/p>\n<p>Set the value in \u00a0the\u00a0post_date_gmt field of your wp_posts table to the default value.<\/p>\n<pre>\nRun the following line of code in your phpMyAdmin Query box.\nIf you have changed the prefix of your WordPress tables in\nyour database, be sure to change wp_ prefix to match yours.\n\nUPDATE wp_posts SET post_date_gmt = &#39;0000-00-00 00:00:00&#39; WHERE post_type =&#39;post&#39; AND post_status = &#39;draft&#39;\n\n<\/pre>\n<h3>How to Access phpMyAdmin on Your Web Host<\/h3>\n<p>If you need help accessing phpMyAdmin on your host here is how you can find help:\n<a href=\"http:\/\/www.jbaker.info\/help-with-using-phpmyadmin\/\">Help With Using phpMyAdmin<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Use this SQL Query Set the value in \u00a0the\u00a0post_date_gmt field of your wp_posts table to the default value. Run the following line of code in your phpMyAdmin Query box. If you have changed the prefix of your WordPress tables in your database, be sure to change wp_ prefix to match yours. UPDATE wp_posts SET post_date_gmt&#8230;  <a href=\"https:\/\/www.jbaker.info\/demo05\/how-to-clear-the-scheduled-date-for-all-wordpress-draft-posts\/\" class=\"more-link\" title=\"Read How to Clear the Scheduled Date for all WordPress Draft Posts\">Read more &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-8776","post","type-post","status-publish","format-standard","hentry","category-programming-tips-and-tricks"],"_links":{"self":[{"href":"https:\/\/www.jbaker.info\/demo05\/wp-json\/wp\/v2\/posts\/8776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jbaker.info\/demo05\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jbaker.info\/demo05\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jbaker.info\/demo05\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jbaker.info\/demo05\/wp-json\/wp\/v2\/comments?post=8776"}],"version-history":[{"count":1,"href":"https:\/\/www.jbaker.info\/demo05\/wp-json\/wp\/v2\/posts\/8776\/revisions"}],"predecessor-version":[{"id":8838,"href":"https:\/\/www.jbaker.info\/demo05\/wp-json\/wp\/v2\/posts\/8776\/revisions\/8838"}],"wp:attachment":[{"href":"https:\/\/www.jbaker.info\/demo05\/wp-json\/wp\/v2\/media?parent=8776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jbaker.info\/demo05\/wp-json\/wp\/v2\/categories?post=8776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jbaker.info\/demo05\/wp-json\/wp\/v2\/tags?post=8776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}