You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2016/09/13 22:44:21 UTC

[jira] [Commented] (HIVE-14579) Add support for date extract and floor

    [ https://issues.apache.org/jira/browse/HIVE-14579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15488694#comment-15488694 ] 

Jesus Camacho Rodriguez commented on HIVE-14579:
------------------------------------------------

{{floor (<time> to <timeunit>)}} is equivalent to {{date_trunc(<timeunit>, <time>)}}.

https://www.postgresql.org/docs/9.1/static/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC

> Add support for date extract and floor
> --------------------------------------
>
>                 Key: HIVE-14579
>                 URL: https://issues.apache.org/jira/browse/HIVE-14579
>             Project: Hive
>          Issue Type: Sub-task
>          Components: UDF
>            Reporter: Ashutosh Chauhan
>            Assignee: Jesus Camacho Rodriguez
>
> https://www.postgresql.org/docs/9.1/static/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)