[PHOENIX-1662] Implement missing date/time built-in functions and operators

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: Java SQL gsoc2015 mentor
• Assignee: Unassigned
• Reporter: James R. Taylor
• Created: 14/Feb/15 06:15
• Updated: 09/Mar/16 17:19

Description

Take a look at the typical date functions that are implemented in relational database systems (http://www.postgresql.org/docs/8.1/static/functions-datetime.html) and implement the same for Phoenix in Java following this guide: http://phoenix-hbase.blogspot.com/2013/04/how-to-add-your-own-built-in-function.html

Examples of missing functions include EXTRACT, AGE, the INTERVAL operator, etc.

Issue Links

• is a clone of: PHOENIX-1660 Implement missing math built-in functions
• is related to: PHOENIX-1765 Add DAYOFMONTH built-in function
• is related to: PHOENIX-2754 Add INTERVAL type
• is related to: PHOENIX-1756 Add Month() and Second() built-in functions
• is related to: PHOENIX-1792 Add Week() and Hour() built-ins
• relates to: PHOENIX-1704 Add year() built-in function