You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "noam bulvik (JIRA)" <ji...@apache.org> on 2015/11/19 08:56:10 UTC

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

noam bulvik created PHOENIX-2433:
------------------------------------

             Summary: support additional time units (like week/month/year) in Trunc() round() and Ceil() 
                 Key: PHOENIX-2433
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2433
             Project: Phoenix
          Issue Type: Improvement
            Reporter: noam bulvik


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



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