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.