[PHOENIX-2433] support additional time units (like week/month/year) in Trunc() round() and Ceil()

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.7.0
• Labels: newbie
• Assignee: maghamravikiran
• Reporter: noam bulvik
• Created: 19/Nov/15 07:55
• Updated: 28/Oct/22 12:49
• Resolved: 13/Jan/16 19:02

Description

currently the time units that are supported in trunk(), round(), ceil are day/hour/minute/seconds/milliseconds.
It should support also other values like week, month, year
You can see how it is documented for Oracle in http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions201.htm and different supported level in http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions230.htm#i1002084

Issue Links

• causes: PHOENIX-6822 Multiplier for Temporal round/floor/ceiling functions is not implemented and/or poorly defined
• causes: PHOENIX-6823 calling Joda-based round() function on temporal PK field causes division by zero error