phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Trunc () on date questions
Date Wed, 18 Nov 2015 19:51:30 GMT
Yes, please file a JIRA.

On Wed, Nov 18, 2015 at 10:06 AM, Stephen Wilcoxon <wilcoxon@gmail.com>
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 <alok@cloudability.com>
> 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
>>
>> 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