Yes, please file a JIRA. On Wed, Nov 18, 2015 at 10:06 AM, Stephen Wilcoxon <[email protected]> wrote:
> I think he's asking for trunc() to support the higher levels (not just > ways to retrieve the higher level parts). Although, it's a little unclear > to me exactly what the expected behavior is for a date(time) truncated to > say month is (yyyy-mm-01, yyyy-mm-<last day>, or something else). I > suspect it likely varies by implementation since (date_)trunc is not a > standard function. > > On Wed, Nov 18, 2015 at 12:00 PM, Alok Singh <[email protected]> > wrote: > >> 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. >>> >> >> >
