{"id":586,"date":"2019-07-31T14:58:53","date_gmt":"2019-07-31T14:58:53","guid":{"rendered":"https:\/\/dapliw.org.ve\/?p=586"},"modified":"2024-02-28T16:08:55","modified_gmt":"2024-02-28T20:08:55","slug":"cakephp-3-8-seleccionar-registros-por-mes-y-ano","status":"publish","type":"post","link":"https:\/\/saemas.com\/sitio_web\/cakephp-3-8-seleccionar-registros-por-mes-y-ano\/","title":{"rendered":"Cakephp 3.5 – Seleccionar registros por mes y a\u00f1o"},"content":{"rendered":"

Para seleccionar aquellos registros de una tabla que en la columna \u00abcreated\u00bb contengan el mes ’07’ y a\u00f1o ‘2019’:<\/p>\n

\n$mes = '07';\n$ano = '2019';\n$registrosSeleccionados = $this->Concepts->find('all', ['conditions' => \n        ['MONTH(created)' => $mes, \n        'YEAR(created)' => $ano],\n\t'order' => ['id' => 'ASC'] ]);\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
Para seleccionar aquellos registros de una tabla que en la columna \u00abcreated\u00bb contengan el mes ’07’ y a\u00f1o ‘2019’: $mes = ’07’; $ano = ‘2019’; $registrosSeleccionados = $this->Concepts->find(‘all’, [‘conditions’ => [‘MONTH(created)’ => $mes, ‘YEAR(created)’ => $ano], ‘order’ => [‘id’ => ‘ASC’] ]);<\/p>\n","protected":false},"author":1,"featured_media":659,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"material-hide-sections":[],"footnotes":""},"categories":[11],"tags":[12],"class_list":["post-586","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cakephp","tag-cakephp"],"_links":{"self":[{"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/posts\/586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/comments?post=586"}],"version-history":[{"count":1,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/posts\/586\/revisions"}],"predecessor-version":[{"id":2187,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/posts\/586\/revisions\/2187"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/media?parent=586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/categories?post=586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saemas.com\/sitio_web\/wp-json\/wp\/v2\/tags?post=586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}