[
https://issues.apache.org/jira/browse/PHOENIX-1781?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor reopened PHOENIX-1781:
-----------------------------------
That's good information, [~cartershanklin], especially the part about other
databases having now().
[~ayingshu] - take a look at TruncFunction.java. This is what you'd need to do
for a NOW function. You just provide the @BuiltInFunction annotation that uses
CurrentDateParseNode.class as the nodeClass attribute.
> Add Now()
> ---------
>
> Key: PHOENIX-1781
> URL: https://issues.apache.org/jira/browse/PHOENIX-1781
> Project: Phoenix
> Issue Type: Improvement
> Reporter: Alicia Ying Shu
> Assignee: Alicia Ying Shu
>
> Phoenix currently supports current_date() that returns a timestamp.
> From Oracle doc:
> NOW() A timestamp value representing the current date and
> time
> Many customers use Now() for current timestamp and curDate() for current
> Date. Will implement Now() similar to Phoenix current_date() so that
> customers do not need to change their queries.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
