{"id":1574,"date":"2014-04-29T17:23:34","date_gmt":"2014-04-29T22:23:34","guid":{"rendered":"http:\/\/alejandroayala.solmedia.ec\/?p=1574"},"modified":"2014-05-22T23:35:13","modified_gmt":"2014-05-23T04:35:13","slug":"jpqlhql-obtener-una-parte-de-una-fecha-de-un-columna-de-tipo-date-time","status":"publish","type":"post","link":"https:\/\/alejandroayala.solmedia.ec\/?p=1574","title":{"rendered":"JPQL\/HQL Obtener una parte de una Fecha de un columna de tipo Date Time"},"content":{"rendered":"<p>Necesitaba extraer solo el d\u00eda de una fecha y ten\u00eda la sentencia <a href=\"https:\/\/en.wikipedia.org\/wiki\/Sql\" target=\"_blank\">SQL <\/a>para <a href=\"http:\/\/www.oracle.com\/index.html\" target=\"_blank\">Oracle<\/a>:<\/p>\n<p>[sql]<br \/>\nSELECT TO_CHAR(COLUMNA_FECHA,&#8217;dd&#8217;) FROM mi_tabla WHERE &#8230;.<br \/>\n[\/sql]<\/p>\n<p>Ahora para hacer lo mismo, usando <a href=\"https:\/\/en.wikipedia.org\/wiki\/JPQL\" target=\"_blank\">JPQL\/HQL<\/a> con <a href=\"http:\/\/hibernate.org\/\" target=\"_blank\">Hibernate <\/a>se puede hacer lo siguiente:<\/p>\n<p>[java]<br \/>\nSELECT day(columnaFecha) FROM MiTabla WHERE &#8230;<br \/>\n[\/java]<\/p>\n<p>Como puede ser el d\u00eda tambi\u00e9n es posible extraer cierta informaci\u00f3n como las horas, minutos, etc:<\/p>\n<p><strong>second(&#8230;), minute(&#8230;), hour(&#8230;), day(&#8230;), month(&#8230;), year(&#8230;)<\/strong><\/p>\n<p>Para m\u00e1s informaci\u00f3n la guia oficial:<\/p>\n<p><a href=\"http:\/\/docs.jboss.org\/hibernate\/core\/3.6\/reference\/en-US\/html_single\/#queryhql-expressions\" target=\"_blank\">http:\/\/docs.jboss.org\/hibernate\/core\/3.6\/reference\/en-US\/html_single\/#queryhql-expressions<\/a><\/p>\n<p>Y una gu\u00eda bastante completa sobre lo que se puede hacer con JPQL<\/p>\n<p><a href=\"http:\/\/forcedotcom.github.io\/java-sdk\/jpa-queries\" target=\"_blank\">http:\/\/forcedotcom.github.io\/java-sdk\/jpa-queries<\/a><\/p>\n\n<div class=\"twitter-share\"><a href=\"https:\/\/twitter.com\/intent\/tweet?via=a1ejo_ayala\" class=\"twitter-share-button\" data-size=\"large\">Twittear<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Necesitaba extraer solo el d\u00eda de una fecha y ten\u00eda la sentencia SQL para Oracle: [sql] SELECT TO_CHAR(COLUMNA_FECHA,&#8217;dd&#8217;) FROM mi_tabla WHERE &#8230;. [\/sql] Ahora para hacer lo mismo, usando JPQL\/HQL con Hibernate se puede hacer lo siguiente: [java] SELECT day(columnaFecha) FROM MiTabla WHERE &#8230; [\/java] Como puede ser el d\u00eda tambi\u00e9n es posible extraer cierta\u2026 <span class=\"read-more\"><a href=\"https:\/\/alejandroayala.solmedia.ec\/?p=1574\">Leer m\u00e1s &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":690,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[4],"tags":[443,444,173,442,506,203,441,185],"_links":{"self":[{"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=\/wp\/v2\/posts\/1574"}],"collection":[{"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1574"}],"version-history":[{"count":3,"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=\/wp\/v2\/posts\/1574\/revisions"}],"predecessor-version":[{"id":1589,"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=\/wp\/v2\/posts\/1574\/revisions\/1589"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=\/wp\/v2\/media\/690"}],"wp:attachment":[{"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1574"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}