hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Pivovarov (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (HIVE-3942) Add UDF month_add and month_sub
Date Mon, 18 May 2015 20:46:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-3942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Alexander Pivovarov resolved HIVE-3942.
---------------------------------------
    Resolution: Duplicate

Dup of HIVE-9357

> Add UDF month_add and month_sub 
> --------------------------------
>
>                 Key: HIVE-3942
>                 URL: https://issues.apache.org/jira/browse/HIVE-3942
>             Project: Hive
>          Issue Type: New Feature
>          Components: UDF
>    Affects Versions: 0.9.0
>            Reporter: caofangkun
>            Priority: Minor
>         Attachments: HIVE-3942-1.patch
>
>
> hive (default)> desc function extended month_add;
> month_add(start_date, num_months) - Returns the date that is num_months after start_date.
> Synonyms: month_sub
> start_date is a string in the format 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'. num_months
is a number. The time part of start_date is ignored.
> Example:
>    SELECT month_add('2012-04-12', 1) FROM src LIMIT 1; --Return 2012-05-12
>   SELECT month_add('2012-04-12 11:22:31', 1) FROM src LIMIT 1; --Return 2012-05-12
>   SELECT month_add(cast('2012-04-12 11:22:31' as timestamp), 1) FROM src LIMIT 1; --Return
2012-05-12
> hive (default)> desc function extended month_sub;
> month_sub(start_date, num_months) - Returns the date that is num_months after start_date.
> Synonyms: month_add
> start_date is a string in the format 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'. num_months
is a number. The time part of start_date is ignored.
> Example:
>    SELECT month_sub('2012-04-12', 1) FROM src LIMIT 1; --Return 2012-05-12
>   SELECT month_sub('2012-04-12 11:22:31', 1) FROM src LIMIT 1; --Return 2012-05-12
>   SELECT month_sub(cast('2012-04-12 11:22:31' as timestamp), 1) FROM src LIMIT 1; --Return
2012-05-12



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

Mime
View raw message