phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Siva <sbhavan...@gmail.com>
Subject Re: TO_DATE is not working as expected
Date Fri, 01 May 2015 18:04:15 GMT
Hi Gabriel,

Thanks for your response.

You meant to say TO_DATE is actually holding the time portion but it is not
able to display it sqlline?

Can please correct me if I m wrong. createdate column is defined as string
on lead view.

Thanks,
Siva.

On Fri, May 1, 2015 at 3:38 AM, Gabriel Reid <gabriel.reid@gmail.com> wrote:

> Hi Siva,
>
> The TO_DATE function returns a java.sql.Date value, and the string
> representation of the java.sql.Date value is what you're seeing in your
> sqlline session.
>
> The internal long representation of the Date value coming out of TO_DATE
> will represent the date to millisecond granularity however.
>
> - Gabriel
>
> On Fri, May 1, 2015 at 11:50 AM Siva <sbhavanari@gmail.com> wrote:
>
>> Hi,
>>
>> Phoenix TO_DATE is truncating the time portion from date while converting
>> the date. Do I need to change the syntax? As per the documentation syntax
>> seems to be correct.
>>
>> 0: jdbc:phoenix::/hbase> select "createdate", to_date("createdate",
>> 'yyyy-MM-dd HH:mm:ss') from "lead" limit 5;
>>
>> +------------------------------------------+------------------------+
>> |                createdate                | TO_DATE(cf.createdate) |
>> +------------------------------------------+------------------------+
>> | 2015-03-17 00:00:00.000                  | 2015-03-16             |
>> | 2014-04-28 13:31:22.687                  | 2014-04-28             |
>> | 2014-04-29 08:42:09.317                  | 2014-04-29             |
>> | 2014-04-29 08:42:18.167                  | 2014-04-29             |
>> | 2014-04-29 08:42:31.963                  | 2014-04-29             |
>> +------------------------------------------+------------------------+
>> 5 rows selected (0.056 seconds)
>>
>>
>> Thanks,
>> Siva.
>>
>

Mime
View raw message