phoenix-dev 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 Sun, 03 May 2015 03:25:50 GMT
Any help on TO_DATE function?

Thanks

On Fri, May 1, 2015 at 2:49 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message