[ https://issues.apache.org/jira/browse/PHOENIX-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15531179#comment-15531179 ]
James Taylor commented on PHOENIX-3201: --------------------------------------- [~an...@apache.org] - there's a bunch of scalar date functions. See all of the ones derived from DateScalarFunction. None of these consider the phoenix.query.dateFormatTimeZone as far as I know. Please file a separate JIRA if you think they should. What does the SQL spec say? > Implement DAYOFWEEK and DAYOFYEAR built-in functions > ---------------------------------------------------- > > Key: PHOENIX-3201 > URL: https://issues.apache.org/jira/browse/PHOENIX-3201 > Project: Phoenix > Issue Type: Bug > Reporter: James Taylor > Assignee: prakul agarwal > Labels: newbie > Fix For: 4.9.0 > > Attachments: PHOENIX-3201.patch, PHOENIX-3201_4.x-HBase-0.98.patch, > PHOENIX-3201_4.x-HBase-1.1.patch, PHOENIX-3201_master.patch > > > DAYOFWEEK() as documented here: > https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005645 > DAYOFYEAR() as documented here: > https://docs.oracle.com/cd/B19188_01/doc/B15917/sqfunc.htm#i1005676 -- This message was sent by Atlassian JIRA (v6.3.4#6332)