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