Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Labels (2)

Question: Are there any functions which allow date arithmetic with phoenix?

Answer: this is done as a fraction of a day. e.g. to add 12 hours to a day:
> select now(), now() + (0.5) ; 
+---------------------------------+---------------------------------+
| DATE '2017-06-04 16:55:07.989'  | DATE '2017-06-05 04:55:07.989'  |
+---------------------------------+---------------------------------+
| 2017-06-04 16:55:07.989         | 2017-06-05 04:55:07.989         |
+---------------------------------+---------------------------------+
To add 15 minutes you would use (15/1440). ie.
0: jdbc:phoenix:> select now(), now() + (0.010416666666667) ;
+---------------------------------+---------------------------------+
| DATE '2017-06-04 16:56:31.492'  | DATE '2017-06-04 17:11:31.492'  |
+---------------------------------+---------------------------------+
| 2017-06-04 16:56:31.492         | 2017-06-04 17:11:31.492         |
+---------------------------------+---------------------------------+
1 row selected (0.024 seconds)
See also: RMP-9148 "Provide Date arithmetic functions for Phoenix"
1,544 Views
0 Kudos
Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
1 of 1
Last update:
‎06-11-2017 09:48 AM
Updated by:
 
Contributors
Top Kudoed Authors