phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alok Singh <a...@cloudability.com>
Subject Re: Trunc () on date questions
Date Wed, 18 Nov 2015 18:00:36 GMT
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

alok@cloudability.com

On Wed, Nov 18, 2015 at 6:50 AM, Bulvik, Noam <Noam.Bulvik@teoco.com> 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.
>

Mime
View raw message