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. >> > >
