Have you looked at supported date/time functions here: https://phoenix.apache.org/language/functions.html e.g. WEEK(timestamp_column) or WEEK(to_date('YYYY-mm-dd')) will give you the week.
Alok Alok [email protected] On Wed, Nov 18, 2015 at 6:50 AM, Bulvik, Noam <[email protected]> wrote: > Hi, > > In other implementations of SQL (like Oracle and impala) trunc() on date > support also date parts higher than day level (for example WEEK, MONTH, > YEAR) – any chance it can be supported also in phoenix ? > > should I open JIRA for it? > > > > > > Regards, > > > > *Noam * > > > > ------------------------------ > > PRIVILEGED AND CONFIDENTIAL > PLEASE NOTE: The information contained in this message is privileged and > confidential, and is intended only for the use of the individual to whom it > is addressed and others who have been specifically authorized to receive > it. If you are not the intended recipient, you are hereby notified that any > dissemination, distribution or copying of this communication is strictly > prohibited. If you have received this communication in error, or if any > problems occur with transmission, please contact sender. Thank you. >
