{"id":217,"date":"2014-06-29T14:32:22","date_gmt":"2014-06-29T14:45:03","guid":{"rendered":"https:\/\/58c3amysql-datetime-arithmetic.png"},"modified":"2015-07-16T17:28:07","modified_gmt":"2015-07-16T23:28:07","slug":"buscar-solo-fecha-en-un-campo-datetime-en-mysql","status":"publish","type":"post","link":"https:\/\/emanuelpaxtian.com\/blog\/buscar-solo-fecha-en-un-campo-datetime-en-mysql\/","title":{"rendered":"Buscar solo fecha en un campo datetime en mysql"},"content":{"rendered":"<p>En algunas ocasiones deseamos buscar\u00a0en un campo datetime de mysql solo la fecha esto es algo relativamente f\u00e1cil para ellos deberemos usar date() quedando de esta forma nuestra consulta.<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"brush: sql\">Select * from tablas where date(campo_datetime)=\u20192014-06-15\u2019<\/pre>\n<p>De esta forma estamos indicando que nom\u00e1s filtre por la fecha que si no pusi\u00e9ramos date nos buscar\u00eda datos exactos hasta en los segundos<\/p>\n","protected":false},"excerpt":{"rendered":"<p>En algunas ocasiones deseamos buscar\u00a0en un campo datetime de mysql solo la fecha esto es algo relativamente f\u00e1cil para ellos deberemos usar date() quedando de esta forma nuestra consulta. &nbsp;&hellip;<\/p>\n","protected":false},"author":1,"featured_media":457,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"class_list":["post-217","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/posts\/217","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/comments?post=217"}],"version-history":[{"count":0,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/posts\/217\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/media\/457"}],"wp:attachment":[{"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/media?parent=217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/categories?post=217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/tags?post=217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}