[ https://issues.apache.org/jira/browse/HIVE-5810?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anandha L Ranganathan updated HIVE-5810: ---------------------------------------- Summary: create a function add_date as exists in mysql (was: create a function ADDDATE as exists in mysql ) > create a function add_date as exists in mysql > ------------------------------------------------ > > Key: HIVE-5810 > URL: https://issues.apache.org/jira/browse/HIVE-5810 > Project: Hive > Issue Type: Improvement > Reporter: Anandha L Ranganathan > Assignee: Anandha L Ranganathan > Original Estimate: 40h > Remaining Estimate: 40h > > MySQL has ADDDATE(date,INTERVAL expr unit). > Similarly in Hive we can have (date,unit,expr). > For example, > ADDDATE('2013-11-09','DAY',2) will return 2013-11-11. > ADDDATE('2013-11-09','Month',2) will return 2014-01-09. > ADDDATE('2013-11-09','Year',2) will return 2014-11-09. > Here Unit is DAY/Month/Year -- This message was sent by Atlassian JIRA (v6.1#6144)